PandasExamples
Change the value of one or more cells. Can change a specific cell, cells in a row, cells in a column, a mix of those, or cells that meet a condition
Removes rows that contain missing values or meet a given condition
Add a column to a dataframe
Gets the average value of one or more columns
Casts a column to a different data type
Creates a copy of a column within a datframe
Calculates the correlation between columns within the dataframe
Gets the data types of one or more colums in a dataframe
Extracts one or more columns from a dataframe into a new dataframe
Creates a for loop that iterates over the columns
Gets one or more columns from a dataframe and returns each column as a series variable
Writes the columns of a dataframe into the code file
Gets the maximum value of one or more columns
Gets the mean value of one or more columns
Gets the median value of one or more columns
Gets the minimum value of one or more columns
Gets the most commonly occuring value of one or more columns
Performs an operation to one column, or between columns
Gets the quantiles / percentages of one or more columns
Rearranges columns within a dataframe to place the stated columns as the first columns in the dataframe
Removes one or more columns from a dataframe
Renames one or more columns within a dataframe by either renaming the column, adding a suffix or prefic, or portions of column names that match a pattern
Rounds the values of a column to the nearest multiple of the given value
Gets the standard deviation of one or more columns
Calculates the sum of one or more columns
Gets the variance of one or more columns
Reads from a csv file and creates a dataframe
Combines one or more dataframes together by placing the rows of the second dataframe after the rows of the first
Makes a copy or clone of the current dataframe
Gives a description of each columns in the dataframe
Rearranges columns within a dataframe to place the stated columns as the first columns in the dataframe
Saves / writes a dataframe to a csv or xlsx file
Shuffles a dataframe
Joins two dataframes together on a given or implied column
Changes the focus for following seeds to the specified dataframe or variable
Use Normalize seed with --minMax. Normalize one or more columns using a min max scaler
Returns a dataframe containing only rows that meet a specific criteria from a query / filter
Creates a dataframe with a random number of columns, rows, and values
Removes non-standard ascii characters, such as non-character, non-numeric, and non-punctual characters, from a dataframe or column.
Resets the indexes within a dataframe, useful if rows have been inserted or removed
Categorizes rows within a dataframe based on a specified criteria
Counts the number of cells or rows or meet a given condition
Counts the number of duplicates rows for all or some columns
Creates a for loop that iterates over each row
Gets 1 of more rows from a dataframe or rows that meet a given condition
Removes rows that contain missing values or meet a given condition
Sort rows either ascending or descending based on the values in one or more columns
See the top n rows of a dataframe using the head() method
Makes following dataframe head calls print all rows, use with CAUTION