Pandas Roadmap

Data Structures

• pandas.Series()

• pandas.DataFrame()

Data Input/Output

• pandas.read_csv()

• pandas.read_excel()

• DataFrame.to_csv()

• DataFrame.to_excel()

Data Exploration

• DataFrame.head()

• DataFrame.tail()

• DataFrame.info()

• DataFrame.describe()

Indexing and Selection

• DataFrame.loc[]

• DataFrame.iloc[]

• DataFrame.set_index()

• DataFrame.reset_index()

Filtering and Querying

• DataFrame[condition]

• DataFrame.query()

Missing Data Handling

• DataFrame.dropna()

• DataFrame.fillna()

Grouping and Aggregation

• DataFrame.groupby()

• GroupBy.agg()

Sorting and Ranking

• DataFrame.sort_values()

• DataFrame.sort_index()

• Series.rank()

Merging and Joining

• pandas.concat()

• DataFrame.merge()

• DataFrame.join()

Time Series Operations

• pandas.to_datetime()

• DataFrame.resample()

Statistical Functions

• Series.mean()

• Series.sum()

• Series.std()

• DataFrame.corr()

• DataFrame.cov()

Others

• DataFrame.pivot_table()

• DataFrame.iterrows()

• DataFrame.duplicated()

• DataFrame.drop_duplicates()

• DataFrame.apply()