Appendix L — Methods on a Pandas DataFrame

For a full interactive list see the W3 Schools Page

Method	Description
abs	Return a DataFrame with the absolute value of each value
add	Adds the values of a DataFrame with the specified value(s)
add_prefix	Prefix all labels
add_suffix	Suffix all labels
agg	Apply a function or a function name to one of the axis of the DataFrame
aggregate	Apply a function or a function name to one of the axis of the DataFrame
align	Aligns two DataFrames with a specified join method
all	Return True if all values in the DataFrame are True, otherwise False
any	Returns True if any of the values in the DataFrame are True, otherwise False
append	Append new columns
applymap	Execute a function for each element in the DataFrame
apply	Apply a function to one of the axis of the DataFrame
assign	Assign new columns
astype	Convert the DataFrame into a specified dtype
at	Get or set the value of the item with the specified label
axes	Returns the labels of the rows and the columns of the DataFrame
bfill	Replaces NULL values with the value from the next row
bool	Returns the Boolean value of the DataFrame
columns	Returns the column labels of the DataFrame
combine	Compare the values in two DataFrames, and let a function decide which values to keep
combine_first	Compare two DataFrames, and if the first DataFrame has a NULL value, it will be filled with the respective value from the second DataFrame
compare	Compare two DataFrames and return the differences
convert_dtypes	Converts the columns in the DataFrame into new dtypes
corr	Find the correlation (relationship) between each column
count	Returns the number of not empty cells for each column/row
cov	Find the covariance of the columns
copy	Returns a copy of the DataFrame
cummax	Calculate the cumulative maximum values of the DataFrame
cummin	Calculate the cumulative minmum values of the DataFrame
cumprod	Calculate the cumulative product over the DataFrame
cumsum	Calculate the cumulative sum over the DataFrame
describe	Returns a description summary for each column in the DataFrame
diff	Calculate the difference between a value and the value of the same column in the previous row
div	Divides the values of a DataFrame with the specified value(s)
dot	Multiplies the values of a DataFrame with values from another array-like object, and add the result
drop	Drops the specified rows/columns from the DataFrame
drop_duplicates	Drops duplicate values from the DataFrame
droplevel	Drops the specified index/column(s)
dropna	Drops all rows that contains NULL values
dtypes	Returns the dtypes of the columns of the DataFrame
duplicated	Returns True for duplicated rows, otherwise False
empty	Returns True if the DataFrame is empty, otherwise False
eq	Returns True for values that are equal to the specified value(s), otherwise False
equals	Returns True if two DataFrames are equal, otherwise False
eval	Evaluate a specified string
explode	Converts each element into a row
ffill	Replaces NULL values with the value from the previous row
fillna	Replaces NULL values with the specified value
filter	Filter the DataFrame according to the specified filter
first	Returns the first rows of a specified date selection
floordiv	Divides the values of a DataFrame with the specified value(s), and floor the values
ge	Returns True for values greater than, or equal to the specified value(s), otherwise False
get	Returns the item of the specified key
groupby	Groups the rows/columns into specified groups
gt	Returns True for values greater than the specified value(s), otherwise False
head	Returns the header row and the first 5 rows, or the specified number of rows
iat	Get or set the value of the item in the specified position
idxmax	Returns the label of the max value in the specified axis
idxmin	Returns the label of the min value in the specified axis
iloc	Get or set the values of a group of elements in the specified positions
index	Returns the row labels of the DataFrame
infer_objects	Change the dtype of the columns in the DataFrame
info	Prints information about the DataFrame
insert	Insert a column in the DataFrame
interpolate	Replaces not-a-number values with the interpolated method
isin	Returns True if each elements in the DataFrame is in the specified value
isna	Finds not-a-number values
isnull	Finds NULL values
items	Iterate over the columns of the DataFrame
iteritems	Iterate over the columns of the DataFrame
iterrows	Iterate over the rows of the DataFrame
itertuples	Iterate over the rows as named tuples
join	Join columns of another DataFrame
last	Returns the last rows of a specified date selection
le	Returns True for values less than, or equal to the specified value(s), otherwise False
loc	Get or set the value of a group of elements specified using their labels
lt	Returns True for values less than the specified value(s), otherwise False
keys	Returns the keys of the info axis
kurtosis	Returns the kurtosis of the values in the specified axis
mask	Replace all values where the specified condition is True
max	Return the max of the values in the specified axis
mean	Return the mean of the values in the specified axis
median	Return the median of the values in the specified axis
melt	Reshape the DataFrame from a wide table to a long table
memory_usage	Returns the memory usage of each column
merge	Merge DataFrame objects
min	Returns the min of the values in the specified axis
mod	Modules (find the remainder) of the values of a DataFrame
mode	Returns the mode of the values in the specified axis
mul	Multiplies the values of a DataFrame with the specified value(s)
ndim	Returns the number of dimensions of the DataFrame
ne	Returns True for values that are not equal to the specified value(s), otherwise False
nlargest	Sort the DataFrame by the specified columns, descending, and return the specified number of rows
notna	Finds values that are not not-a-number
notnull	Finds values that are not NULL
nsmallest	Sort the DataFrame by the specified columns, ascending, and return the specified number of rows
nunique	Returns the number of unique values in the specified axis
pct_change	Returns the percentage change between the previous and the current value
pipe	Apply a function to the DataFrame
pivot	Re-shape the DataFrame
pivot_table	Create a spreadsheet pivot table as a DataFrame
pop	Removes an element from the DataFrame
pow	Raise the values of one DataFrame to the values of another DataFrame
prod	Returns the product of all values in the specified axis
product	Returns the product of the values in the specified axis
quantile	Returns the values at the specified quantile of the specified axis
query	Query the DataFrame
radd	Reverse-adds the values of one DataFrame with the values of another DataFrame
rdiv	Reverse-divides the values of one DataFrame with the values of another DataFrame
reindex	Change the labels of the DataFrame
rename	Change the labels of the axes
rename_axis	Change the name of the axis
reorder_levels	Re-order the index levels
replace	Replace the specified values
reset_index	Reset the index
rfloordiv	Reverse-divides the values of one DataFrame with the values of another DataFrame
rmod	Reverse-modules the values of one DataFrame to the values of another DataFrame
rmul	Reverse-multiplies the values of one DataFrame with the values of another DataFrame
round	Returns a DataFrame with all values rounded into the specified format
rpow	Reverse-raises the values of one DataFrame up to the values of another DataFrame
rsub	Reverse-subtracts the values of one DataFrame to the values of another DataFrame
rtruediv	Reverse-divides the values of one DataFrame with the values of another DataFrame
sample	Returns a random selection elements
sem	Returns the standard error of the mean in the specified axis
select_dtypes	Returns a DataFrame with columns of selected data types
shape	Returns the number of rows and columns of the DataFrame
set_axis	Sets the index of the specified axis
set_flags	Returns a new DataFrame with the specified flags
set_index	Set the Index of the DataFrame
size	Returns the number of elements in the DataFrame
skew	Returns the skew of the values in the specified axis
sort_index	Sorts the DataFrame according to the labels
sort_values	Sorts the DataFrame according to the values
squeeze	Converts a single column DataFrame into a Series
stack	Reshape the DataFrame from a wide table to a long table
std	Returns the standard deviation of the values in the specified axis
sum	Returns the sum of the values in the specified axis
sub	Subtracts the values of a DataFrame with the specified value(s)
swaplevel	Swaps the two specified levels
T	Turns rows into columns and columns into rows
tail	Returns the headers and the last rows
take	Returns the specified elements
to_xarray	Returns an xarray object
transform	Execute a function for each value in the DataFrame
transpose	Turns rows into columns and columns into rows
truediv	Divides the values of a DataFrame with the specified value(s)
truncate	Removes elements outside of a specified set of values
update	Update one DataFrame with the values from another DataFrame
value_counts	Returns the number of unique rows
values	Returns the DataFrame as a NumPy array
var	Returns the variance of the values in the specified axis
where	Replace all values where the specified condition is False
xs	Returns the cross-section of the DataFrame