Pandas Data Wrangling

• Drop rows/columns of a pandas dataframe
• Removing rows/columns of a pandas dataframe based on null values
• Rename rows/columns of a pandas dataframe
• Selecting column/index of a dataframe based on their names using filter function
• Convert wide-form dataframe to long-form dataframe
• Convert long-form dataframe to wide-form dataframe
• Groupby different cases
• Merging two dataframes
• Transpose of a dataframe
• Find index of maximum or minimum value in a pandas series
• Concatenating pandas dataframes
• Selecting columns of dataframe based on data type
• Obtaining list of all columns having null values
• Handling missing values
• Changing data type of pandas series
• Rbind a pandas series to a pandas dataframe
• Calculating rank of values in numerical columns of a dataframe
• Using Pandas cut - Continuous to categorical
• Pandas apply function on series/dataframe

Multi-level Pandas Dataframe

• Read excel file with multiple headers and ignoring the initial rows of the sheet. Also translate some columns to a single level columns by using set_index
• Selecting columns from multi-index dataframe
• Querying multi-index pandas dataframe

Data Exploration

• Pandas pivot table and frequency table/crosstab
• Checking presnce of NA/inf/-inf in rows/columns of a dataframe

---

Working with Dates and Time

• Reading dates using pandas
• Working with dates using pandas
• Working with time using pandas
• Adding days/month/years to a pandas datetime object series