Pandas Listing

Pandas Listing on “Operate”

This listing should include all ‘building blocks’ that are needed in the stories. The order follows CRUD (Create, Read, Update, Delete). It is particularly designed to be used with searching (CTRL+F).

Item	Category	Task
Dataframe	Meta data	Get number of rows
Dataframe	Meta data	Get number of columns
Dataframe	Meta data	Get data types of columns
Dataframe	Meta data	Get some statistics on the dataframe content
Dataframe	Index	Set index
Dataframe	Application to all cells	Transpose dataframe
Dataframe	Application to all cells	Fill all missing values
Dataframe	Application to all cells	Round all floats
Dataframe	Application to all cells	Multiply with a value
Dataframe	Application to all cells	Convert from wide to long format
Dataframe	Application to all cells	Convert from long to wide format
Dataframe	Application to all cells	Split apply combine
Dataframe	More dataframes	Vertically concatenate dataframes
Dataframe	More dataframes	Horizontally concatenate dataframes
Dataframe	More dataframes	Merge dataframes
Dataframe	More dataframes	Add another dataframe
Columns	Create	Append new column to the end
Columns	Create	Append a new column B based on values in column A
Columns	Create	Append a column with the sum of other columns
Columns	Create	Insert new column at a specified position
Columns	Read Columns	Read column names
Columns	Slice Columns	Select a subset of columns
Columns	Slice Columns	Keep a subset of columns
Columns	Update Columns	Rename columns
Columns	Update Columns	Reorder existing columns
Columns	Update Columns	Add a prefix or suffix to all columns
Columns	Update Cells	Convert the type of a column
Columns	Update Cells	Update some numerical values
Columns	Update Cells	Update some string values
Columns	Update Cells	Update column values on condition
Columns	Update Cells	Modify column B based on values in column A
Columns	Update Cells	Divide a column
Columns	Update Cells	Divide a column by another column
Columns	Update Cells	Check for uniqueness
Columns	Update Cells	Keep unique values by dropping duplicates
Columns	Delete	Delete columns by name
Columns	Delete	Delete columns by position
Columns	Delete	Delete last column
Rows	Create	Append a row at the end
Rows	Create	Append a row with the sum of columns
Rows	Create	Insert a new row at a specified position
Rows	Read row	Read a row by index
Rows	Read rows	Read rows by position
Rows	Read cell	Read a cell by columns and index
Rows	Read rows	Read rows by values in columns
Rows	Slice rows	Slice first or last rows
Rows	Slice rows	Slice rows by positions and step size
Rows	Update Cells	Change the values of a row
Rows	Sort	Sort by a column
Rows	Sort	Sort by several columns in mixed directions
Rows	Delete	Delete rows on condition
Rows	Delete	Remove rows by keeping other columns

This table was generated using a dataframe. You find much more info on the pages linked to above.

Pandas Listing on “Operate”

Links

Legal