Python Pandas Flashcards
What are pandas in Python?
A data analysis and manipulation library.
How do you import pandas in Python?
import pandas as pd
What is a DataFrame in pandas?
A 2D labeled data structure with columns of potentially different types.
What is a Series in pandas?
A 1D labeled array capable of holding any data type.
How do you create a DataFrame from a dictionary?
pd.DataFrame({‘col1’: [1
How do you read a CSV file with pandas?
pd.read_csv(‘file.csv’)
How do you write a DataFrame to a CSV file?
df.to_csv(‘file.csv’
How do you display the first 5 rows of a DataFrame?
df.head()
How do you display the last 5 rows of a DataFrame?
df.tail()
How do you get DataFrame column names?
df.columns
How do you get DataFrame index values?
df.index
How do you get a quick summary of a DataFrame?
df.info()
How do you get statistical summary of numeric columns?
df.describe()
How do you select a single column from a DataFrame?
df[‘column_name’]
How do you select multiple columns from a DataFrame?
df[[‘col1’
How do you select rows by index?
df.loc[0] or df.iloc[0]
How do you filter rows by condition?
df[df[‘col’] > 10]
How do you add a new column to a DataFrame?
df[‘new_col’] = values
How do you drop a column from a DataFrame?
df.drop(‘col’
How do you drop a row from a DataFrame?
df.drop(index
How do you rename columns in a DataFrame?
df.rename(columns={‘old’: ‘new’}
How do you check for missing values?
df.isnull()
How do you fill missing values with 0?
df.fillna(0)
How do you drop rows with missing values?
df.dropna()
