Reading CSV with options (sep, header, encoding) in Data Analysis Python - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the sep parameter do when reading a CSV file?

The sep parameter tells the program which character separates the columns in the CSV file. For example, sep=',' means columns are separated by commas.

beginner

How does the header parameter affect reading a CSV file?

The header parameter tells the program which row to use as the column names. For example, header=0 means the first row is the header. If header=None, no row is used as header and columns get default names.

beginner

Why is the encoding parameter important when reading CSV files?

The encoding parameter tells the program how to read the text characters in the file. Different files may use different encodings like utf-8 or latin1. Using the wrong encoding can cause errors or wrong characters.

intermediate

Example: How to read a CSV file with semicolon separators, no header row, and latin1 encoding?

Use pd.read_csv('file.csv', sep=';', header=None, encoding='latin1'). This tells pandas to split columns by semicolon, treat the file as having no header, and read text using latin1 encoding.

beginner

What happens if you don't specify the header parameter when reading a CSV?

By default, pandas assumes the first row (header=0) contains column names. If your file has no header, this can cause the first row of data to be used as headers, which is usually wrong.

What does sep='\t' mean when reading a CSV file?

A Columns are separated by semicolons

B Columns are separated by commas

C Columns are separated by spaces

D Columns are separated by tabs

The '\t' character represents a tab, so sep='\t' means columns are separated by tabs.

If a CSV file has no header row, which header value should you use?

A None

B 0

C 1

D -1

Use header=None to tell pandas the file has no header row.

Which encoding is most commonly used for CSV files with English text?

A utf-8

B ascii

C latin1

D utf-16

utf-8 is the most common encoding for English and many other languages.

What happens if you use the wrong encoding when reading a CSV?

A The file reads faster

B You get an error or wrong characters

C The file size changes

D Nothing happens

Wrong encoding can cause errors or display wrong characters.

How do you tell pandas to read a CSV file where columns are separated by semicolons?

A sep=','

B encoding=';'

C sep=';'

D header=';'

Use sep=';' to specify semicolon as the column separator.

Explain how to read a CSV file that uses tabs as separators, has no header row, and uses UTF-8 encoding.

Think about parameters for separator, header, and encoding.

Why is it important to specify the correct encoding when reading CSV files?

Consider what happens if encoding is wrong.

Practice

1. What does the sep parameter do when reading a CSV file with pandas?

easy

A. It sets the encoding type of the file.

B. It tells pandas which row to use as column headers.

C. It specifies the character that separates columns in the file.

D. It defines the number of rows to skip at the start.

Solution

1. Step 1: Understand the role of sep

   The sep parameter tells pandas what character separates columns in the CSV file, like a comma or tab.

2. Step 2: Differentiate from other parameters

   Other parameters like header and encoding serve different purposes, so sep is specifically for column separation.

3. Final Answer:

   It specifies the character that separates columns in the file. -> Option C

4. Quick Check:

   sep = column separator [OK]

Hint: Remember: sep means separator character [OK]

Common Mistakes:

• Confusing sep with encoding
• Thinking sep sets header row
• Assuming sep skips rows

2. Which of the following is the correct syntax to read a CSV file named data.csv with semicolon-separated columns and no header row using pandas?

easy

A. pd.read_csv('data.csv', sep=';', header=0)

B. pd.read_csv('data.csv', sep=';', header=None)

C. pd.read_csv('data.csv', encoding='utf-8')

D. pd.read_csv('data.csv', sep=',', header=None)

Solution

1. Step 1: Set separator to semicolon

   Use sep=';' to tell pandas columns are separated by semicolons.

2. Step 2: Specify no header row

   Use header=None to indicate the file has no header row and pandas should assign default column names.

3. Final Answer:

   pd.read_csv('data.csv', sep=';', header=None) -> Option B

4. Quick Check:

   sep=';' and header=None for no headers [OK]

Hint: Use header=None if no column names in file [OK]

Common Mistakes:

• Using header=0 when no header exists
• Forgetting to set sep for semicolon
• Confusing encoding with separator

3. Given a CSV file file.csv with tab-separated values and UTF-16 encoding, what will be the output of this code?

import pandas as pd

df = pd.read_csv('file.csv', sep='\t', encoding='utf-16')
print(df.columns.tolist())

Assuming the first row contains column names: 'Name', 'Age', 'City'.

medium

A. ['Name', 'Age', 'City']

B. ['Unnamed: 0', 'Unnamed: 1', 'Unnamed: 2']

C. Error due to wrong encoding

D. ['Name\tAge\tCity']

Solution

1. Step 1: Read CSV with correct separator and encoding

   The code uses sep='\t' for tab separation and encoding='utf-16' matching the file's format, so pandas reads it correctly.

2. Step 2: Extract column names

   Since the first row has column names, pandas sets them as columns. Printing df.columns.tolist() shows ['Name', 'Age', 'City'].

3. Final Answer:

   ['Name', 'Age', 'City'] -> Option A

4. Quick Check:

   Correct sep and encoding give proper columns [OK]

Hint: Match sep and encoding to file format [OK]

Common Mistakes:

• Using wrong encoding causing errors
• Not setting sep for tab-separated file
• Expecting data instead of column names

4. What is wrong with this code snippet if the CSV file uses pipe (|) as separator and has no header row?

import pandas as pd

df = pd.read_csv('data.csv', sep='|')
print(df.head())

medium

A. Encoding is missing, so it will fail to read.

B. It will raise a FileNotFoundError.

C. The separator is incorrect; should be comma.

D. It assumes the first row is header, causing first data row to be column names.

Solution

1. Step 1: Check separator usage

   The code correctly uses sep='|' matching the file's separator.

2. Step 2: Check header assumption

   By default, pandas assumes the first row is header. Since the file has no header, the first data row becomes column names, which is wrong.

3. Final Answer:

   It assumes the first row is header, causing first data row to be column names. -> Option D

4. Quick Check:

   Set header=None if no header row [OK]

Hint: Use header=None if file has no headers [OK]

Common Mistakes:

• Forgetting header=None for no header files
• Assuming default separator is pipe
• Thinking encoding is always required

5. You have a CSV file saved with semicolon separators, no header row, and encoded in ISO-8859-1. You want to read it into pandas and assign column names ['A', 'B', 'C']. Which code snippet correctly does this?

hard

A. pd.read_csv('file.csv', sep=';', header=None, encoding='ISO-8859-1', names=['A', 'B', 'C'])

B. pd.read_csv('file.csv', sep=',', header=0, encoding='utf-8', names=['A', 'B', 'C'])

C. pd.read_csv('file.csv', sep=';', encoding='utf-8')

D. pd.read_csv('file.csv', sep=';', header=0, encoding='ISO-8859-1')

Solution

1. Step 1: Set separator and encoding correctly

   Use sep=';' for semicolon and encoding='ISO-8859-1' to match file encoding.

2. Step 2: Specify no header and assign column names

   Use header=None because file has no header row, and names=['A', 'B', 'C'] to assign column names manually.

3. Final Answer:

   pd.read_csv('file.csv', sep=';', header=None, encoding='ISO-8859-1', names=['A', 'B', 'C']) -> Option A

4. Quick Check:

   Match sep, encoding, header, and names [OK]

Hint: Use names= with header=None to set columns [OK]

Common Mistakes:

• Using wrong separator or encoding
• Not setting header=None for no header files
• Assigning names without header=None