Why flexible I/O handles real-world data in Data Analysis Python - Challenge Your Understanding

Challenge - 5 Problems

❓ Predict Output

intermediate

What is the output of this code reading a CSV with missing values?

Consider this Python code that reads a CSV file with missing values using pandas. What will be the output of the df.isnull().sum() line?

Data Analysis Python

import pandas as pd
from io import StringIO

data = '''name,age,score
Alice,30,85
Bob,,90
Charlie,25,
,40,70
'''

# Simulate reading CSV from string
csv_data = StringIO(data)
df = pd.read_csv(csv_data)

missing_counts = df.isnull().sum()
print(missing_counts)

A {'name': 1, 'age': 1, 'score': 1}

B {'name': 0, 'age': 1, 'score': 1}

C {'name': 1, 'age': 0, 'score': 1}

D {'name': 1, 'age': 1, 'score': 0}

💡 Hint

Check how many missing values are in each column by counting empty cells.

The CSV has one missing value in each column: 'name' missing in last row, 'age' missing in Bob's row, and 'score' missing in Charlie's row. So each column has exactly one missing value.

❓ data_output

intermediate

How many rows are read when using flexible I/O with different separators?

Given two CSV strings with different separators, what is the number of rows in the DataFrame after reading each with pandas?

Data Analysis Python

import pandas as pd
from io import StringIO

csv_comma = 'id,name\n1,Alice\n2,Bob'
csv_semicolon = 'id;name\n3;Charlie\n4;David'

df_comma = pd.read_csv(StringIO(csv_comma))
df_semicolon = pd.read_csv(StringIO(csv_semicolon), sep=';')

rows_comma = len(df_comma)
rows_semicolon = len(df_semicolon)
print(rows_comma, rows_semicolon)

A 2, 1

B 2, 2

C 1, 2

D 1, 1

💡 Hint

Count the number of data rows in each CSV string after reading.

Both CSV strings have two data rows each. Using the correct separator ensures pandas reads both rows correctly.

❓ visualization

advanced

Which plot shows correct handling of missing data after flexible I/O?

After reading a CSV with missing values, which plot correctly shows the count of missing values per column?

Data Analysis Python

import pandas as pd
import matplotlib.pyplot as plt
from io import StringIO

data = '''A,B,C
1,,3
4,5,
,7,9
'''

df = pd.read_csv(StringIO(data))
missing_counts = df.isnull().sum()

plt.bar(missing_counts.index, missing_counts.values)
plt.title('Missing Values per Column')
plt.ylabel('Count')
plt.show()

A Bar chart with bars for A=1, B=1, C=1

B Line chart with points for A=1, B=1, C=1

C Bar chart with bars for A=0, B=0, C=0

D Pie chart with equal slices for A, B, C

💡 Hint

Look for a bar chart showing counts of missing values per column.

The code counts missing values per column and plots a bar chart. Each column has one missing value, so bars show height 1.

🔧 Debug

advanced

What error does this code raise when reading a malformed CSV?

What error will this code raise when trying to read a CSV string with inconsistent columns?

Data Analysis Python

import pandas as pd
from io import StringIO

data = 'id,name\n1,Alice\n2'

try:
    df = pd.read_csv(StringIO(data))
except Exception as e:
    print(type(e).__name__)

A TypeError

B ValueError

C ParserError

D No error

💡 Hint

Check what pandas does when rows have fewer columns than header.

Pandas raises a ParserError when the number of fields in a row does not match the header.

🚀 Application

expert

How to handle mixed data types in flexible I/O for real-world data?

You have a CSV file where a column contains numbers and text mixed together. Which pandas option helps read this column without errors?

A Use <code>na_filter=False</code> in <code>read_csv</code>

B Use <code>dtype={'column': 'int'}</code> in <code>read_csv</code>

C Use <code>skiprows=1</code> in <code>read_csv</code>

D Use <code>dtype={'column': 'object'}</code> in <code>read_csv</code>

💡 Hint

Think about how to allow mixed types in one column.

Setting the column dtype to 'object' allows pandas to read mixed types as strings without error.

Practice

1. Why is flexible input/output (I/O) important when working with real-world data?

easy

A. Because flexible I/O makes data always clean and error-free

B. Because real-world data comes in many formats and flexible I/O can handle them all

C. Because flexible I/O only works with CSV files

D. Because flexible I/O slows down data processing

Solution

1. Step 1: Understand real-world data formats

   Real-world data can be CSV, Excel, JSON, or others, so we need tools that can read many types.

2. Step 2: Role of flexible I/O

   Flexible I/O means using functions that can read and write different formats easily, like pandas' read_csv or to_excel.

3. Final Answer:

   Because real-world data comes in many formats and flexible I/O can handle them all -> Option B

4. Quick Check:

   Flexible I/O = handles many formats [OK]

Hint: Real data varies; flexible I/O reads many formats [OK]

Common Mistakes:

• Thinking flexible I/O only works with one file type
• Assuming flexible I/O cleans data automatically
• Believing flexible I/O slows down processing

2. Which of the following is the correct way to read a CSV file using pandas in Python?

easy

A. pd.read_csv('data.csv')

B. pd.readExcel('data.csv')

C. pd.load_csv('data.csv')

D. pd.open_csv('data.csv')

Solution

1. Step 1: Recall pandas CSV reading function

   The correct pandas function to read CSV files is read_csv.

2. Step 2: Check syntax correctness

   pd.read_csv('data.csv') is the correct syntax; others are invalid or do not exist.

3. Final Answer:

   pd.read_csv('data.csv') -> Option A

4. Quick Check:

   pandas CSV read = read_csv [OK]

Hint: Use pd.read_csv() to read CSV files [OK]

Common Mistakes:

• Using incorrect function names like readExcel or load_csv
• Confusing read_csv with open or load functions
• Missing the 'pd.' prefix for pandas

3. What will be the output of this code snippet?

import pandas as pd
from io import StringIO
csv_data = 'name,age\nAlice,30\nBob,25'
data = pd.read_csv(StringIO(csv_data))
print(data['age'].tolist())

medium

A. ["Alice", "Bob"]

B. ['30', '25']

C. Error: StringIO not supported

D. [30, 25]

Solution

1. Step 1: Understand StringIO usage

   StringIO allows reading CSV data from a string as if it were a file.

2. Step 2: Check data reading and output

   pd.read_csv reads the CSV string into a DataFrame; data['age'] column contains integers 30 and 25; .tolist() converts it to a list.

3. Final Answer:

   [30, 25] -> Option D

4. Quick Check:

   CSV string to list of ages = [30, 25] [OK]

Hint: StringIO reads string as file; ages are integers [OK]

Common Mistakes:

• Expecting strings instead of integers in the list
• Thinking StringIO is unsupported
• Confusing column names with values

4. Identify the error in this code that tries to save a DataFrame to Excel:

import pandas as pd
df = pd.DataFrame({'A': [1, 2], 'B': [3, 4]})
df.to_excel('output.csv')

medium

A. File extension should be .xlsx, not .csv

B. to_excel() cannot save DataFrames

C. Missing import for Excel writer

D. DataFrame is empty

Solution

1. Step 1: Check file extension for to_excel()

   to_excel() expects an Excel file extension like .xlsx, not .csv.

2. Step 2: Understand file format mismatch

   Saving with .csv extension causes confusion; .csv is for comma-separated files, not Excel format.

3. Final Answer:

   File extension should be .xlsx, not .csv -> Option A

4. Quick Check:

   to_excel needs .xlsx extension [OK]

Hint: Use .xlsx extension with to_excel() [OK]

Common Mistakes:

• Using .csv extension with to_excel()
• Thinking to_excel() cannot save DataFrames
• Assuming missing imports cause error

5. You have a JSON file with nested data and want to convert it into a flat pandas DataFrame. Which approach best uses flexible I/O to handle this real-world data?

hard

A. Use pandas.read_csv() directly on the JSON file

B. Manually open the JSON file and parse it line by line without pandas

C. Use pandas.read_json() with the 'lines=True' parameter and then normalize nested fields

D. Convert JSON to Excel first, then read with pandas.read_excel()

Solution

1. Step 1: Understand JSON reading in pandas

   pandas.read_json() can read JSON files; 'lines=True' helps with line-delimited JSON.

2. Step 2: Flatten nested JSON data

   After reading, pandas.json_normalize() can flatten nested fields into columns for easy analysis.

3. Final Answer:

   Use pandas.read_json() with the 'lines=True' parameter and then normalize nested fields -> Option C

4. Quick Check:

   read_json + normalize = best for nested JSON [OK]

Hint: Use read_json with normalization for nested data [OK]

Common Mistakes:

• Trying to read JSON with read_csv()
• Ignoring nested structure flattening
• Converting formats unnecessarily