WorksheetsFinTech 03-2 Pandas
Total questions: 10
Worksheet time: 5mins
Which are objectives of Unit 03-2 Python-Pandas Day 2?
Built-in DataFrame functions
Pandas vs spreadsheets
Scraping websites with Pandas
What are DataFrames vs Series
Read in and manipulate CSVs
Which is the 1D Pandas data structure?
List
Array
Series
DataFrame
Dictionary
Which is the 2D Pandas data structure?
List
Array
Series
DataFrame
Dictionary
Which are Pandas native functions?
count()
value_counts()
items()
isnull()
append()
Which is the correct Pandas syntax to read in a csv file and assign it to a DataFrame df?
df = read_csv('file.csv')
df = read('file.csv', type = 'csv')
df = pd.read_csv('file.csv')
df = with open('file.csv') as pd.DataFrame
Type the syntax that returns the top 5 rows in DataFrame df with the native Pandas function (not slicing):
(a)
Given col_names = ['A', 'B', 'C', 'D'], set the column names of DataFrame df to col_names:
(a)
You want to clean a column that has extra $ characters. Use _____ to find them and _____ to remove them:
isna(), fillna()
dtype, astype()
contains(), replace()
count(), drop()
How was Unit 03 Day 2 for you?
Any suggestions for improvement?
