Pandas Basics

Front

What is the main pandas data structure?

Back

pandas.core.frame.DataFrame

Front

What function is used to read a CSV file in pandas?

Back

pd.read_csv('csv_name.csv', index_col=0)

Front

Why set index_col=0 in pd.read_csv?

Back

To remove the index column altogether, as pandas sets it to 1 by default.

Front

What does index_col=1 represent in pd.read_csv?

Back

Whatever the first column's data is (ex. could be company name, advisor name, etc...).

Front

How do you import the numpy or pandas modules?

Back

Import pandas as pd

import numpy as np

Front

How do you check the first few rows of a DataFrame in pandas?

Back

Use the df.head() function.

ex. f500.head()

You can enter in an argument into head to signify how many rows you want to view so f500.head(10) will display the first 10 rows.

By default it's set to 5

Front

What method is used to remove missing values in a DataFrame?

Back

Use the df.dropna() method.

Front

How can you concatenate two DataFrames in pandas?

Back

Use the pd.concat([df1, df2]) function.

Front

How do you rename columns in a pandas DataFrame?

Back

Use the df.rename(columns={'old_name': 'new_name'}) method.

Front

What function is used to get a summary of a DataFrame?

Back

Use the df.describe() function to get a statistical summary of the DataFrame.