Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the code to load the CSV file into a DataFrame.
Data Analysis Python
import pandas as pd data = pd.[1]('data.csv')
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using non-existent functions like load_csv or open_csv.
✗ Incorrect
Use pd.read_csv to load CSV files into a DataFrame.
2fill in blank
mediumComplete the code to show the first 5 rows of the DataFrame.
Data Analysis Python
print(data.[1]())
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using methods like top() or show() which do not exist.
✗ Incorrect
The head() method shows the first 5 rows by default.
3fill in blank
hardFix the error in the code to get summary statistics of the DataFrame.
Data Analysis Python
summary = data.[1]() Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using info() which shows data types but not statistics.
✗ Incorrect
The describe() method provides summary statistics like mean and median.
4fill in blank
hardFill both blanks to create a dictionary of word lengths for words longer than 3 letters.
Data Analysis Python
lengths = {word: [1] for word in words if len(word) [2] 3} Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using '<' instead of '>' in the condition.
✗ Incorrect
We use len(word) to get length and filter words with length greater than 3 using >.
5fill in blank
hardFill all three blanks to create a filtered dictionary with uppercase keys and values greater than 0.
Data Analysis Python
result = { [1]: [2] for k, v in data.items() if v [3] 0 } Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using 'k' instead of 'k.upper()' for keys.
✗ Incorrect
Keys are converted to uppercase with k.upper(), values are v, and filtered where v > 0.