Python Pandas Library

Ace your homework & exams now with Quizwiz!

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


Related study sets

Macroeconomics Chapter 33: Aggregate Demand and Aggregate Supply

View Set