Python Pandas Library
df.iat[]
Accesses a scalar value by index position
df.at[]
Accesses a scalar value by label
df.iloc[]
Accesses rows and columns by index position
df.loc[]
Accesses rows and columns by label
df.applymap()
Applies a function element-wise to a DataFrame
df.apply()
Applies a function to each element in a DataFrame.
df.astype()
Changes the data type of a column in a DataFrame
df.isnull()
Checks for missing values in a DataFrame
df.cummax()
Computes the cumulative maximum of a column
df.cummin()
Computes the cumulative minimum of a column
df.cumsum()
Computes the cumulative sum of a column
df.concat()
Concatenates multiple DataFrames along a particular axis
df.pivot()
Creates a pivot table from a DataFrame
df.pivot_table()
Creates a pivot table from a DataFrame
df.pivot_table()
Creates a pivot table from a DataFrame.
df.cut()
Divides a column into bins
df.qcut()
Divides a column into quantile-based bins
df.drop_duplicates()
Drops duplicate rows from a DataFrame
df.dropna()
Drops rows with missing values from a DataFrame
df.drop()
Drops specified columns from a DataFrame
df.fillna()
Fills missing values in a DataFrame
df.describe()
Generates descriptive statistics of a DataFrame
df.groupby()
Groups a DataFrame by one or more columns.
df.map()
Maps values of a Series to another set of values.
df.merge()
Merges two DataFrames based on a common column
df.rolling()
Performs rolling computations on a column
df.info()
Provides a concise summary of a DataFrame.
pd.read_csv()
Reads a CSV file into a DataFrame.
df.rename()
Renames columns in a DataFrame
df.replace()
Replaces values in a DataFrame or Series
df.reset_index()
Resets the index of a DataFrame.
df.sample()
Returns a random sample of rows from a DataFrame
df.columns
Returns the column labels of a DataFrame
df.value_counts()
Returns the count of unique values in a column.
df.dtypes
Returns the data types of the columns in a DataFrame
df.shape
Returns the dimensions of a DataFrame (rows, columns)
df.head()
Returns the first n rows of a DataFrame.
df.tail()
Returns the last n rows of a DataFrame.
df.nunique()
Returns the number of unique values in a column
df.index
Returns the row labels of a DataFrame
df.set_index()
Sets a column as the index of a DataFrame
df.shift()
Shifts the values in a column by
df.sort_values()
Sorts a DataFrame by one or more columns
df.stack()
Stacks the prescribed level(s) from columns to index
df.unstack()
Unstacks the prescribed level(s) from index to columns
df.to_csv()
Writes a DataFrame to a CSV file
df.to_excel()
Writes a DataFrame to an Excel file