Skip to content

Latest commit

 

History

History

dataframe

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
description
Two-dimensional, size-mutable, potentially heterogeneous tabular data.

Dataframe

Attributes

DataFrame.index The index (row labels) of the DataFrame.
DataFrame.columns The column labels of the DataFrame.
DataFrame.ctypes
DataFrame.values
DataFrame.axis
DataFrame.ndim
DataFrame.size
DataFrame.shape

Conversion

DataFrame.asType Cast a pandas object to a specified dtype dtype.
DataFrame.copy Make a copy of this object’s indices and data.

Indexing, iteration

DataFrame.head Return the first n rows
DataFrame.loc Access a group of rows and columns by label(s) or a boolean array.
DataFrame.iloc Purely integer-location based indexing for selection by position.
DataFrame.tail Return the last n rows.
DataFrame.query Query the columns of a DataFrame with a boolean expression.

Binary operator functions

DataFrame.add Get Addition of dataframe and other, element-wise (binary operator add).
DataFrame.sub Get Subtraction of dataframe and other, element-wise (binary operator sub).
DataFrame.mul Get Multiplication of dataframe and other, element-wise (binary operator mul).
DataFrame.div Get Floating division of dataframe and other, element-wise (binary operator truediv).
DataFrame.mod Get Modulo of dataframe and other, element-wise (binary operator mod).
DataFrame.pow Get Exponential power of dataframe and other, element-wise (binary operator pow).
DataFrame.lt Get Less than of dataframe and other, element-wise (binary operator lt).
DataFrame.gt Get Greater than of dataframe and other, element-wise (binary operator gt).
DataFrame.le Get Less than or equal to of dataframe and other, element-wise (binary operator le).
DataFrame.ge Get Greater than or equal to of dataframe and other, element-wise (binary operator ge).
DataFrame.ne Get Not equal to of dataframe and other, element-wise (binary operator ne).
DataFrame.eq Get Equal to of dataframe and other, element-wise (binary operator eq).

Function application & GroupBy

DataFrame.apply Apply a function along an axis of the DataFrame.
DataFrame.groupby Group DataFrame using a mapper or by a Series of columns.
DataFrame.map Map a function on Object along an axis to DataFrame

Computations / descriptive stats

DataFrame.abs Return a Series/DataFrame with absolute numeric value of each element.
DataFrame.corr Compute pairwise correlation of columns, excluding NA/null values.
DataFrame.count Count non-NAN cells for each column or row.
DataFrame.cumMax Return cumulative maximum over a DataFrame or Series axis.
DataFrame.cumMin Return cumulative minimum over a DataFrame or Series axis.
DataFrame.cumProd Return cumulative product over a DataFrame or Series axis.
DataFrame.cumSum Return cumulative sum over a DataFrame or Series axis.
DataFrame.describe Generate descriptive statistics.
DataFrame.max Return the maximum of the values for the requested axis.
DataFrame.mean Return the mean of the values for the requested axis.
DataFrame.median Return the median of the values for the requested axis.
DataFrame.min Return the minimum of the values for the requested axis.
DataFrame.mode Get the mode(s) of each element along the selected axis.
DataFrame.round Round a DataFrame to a variable number of decimal places.
DataFrame.sum Return the sum of the values for the requested axis.
DataFrame.std Return sample standard deviation over requested axis.
DataFrame.var Return unbiased variance over requested axis.
DataFrame.nUnique Count distinct observations over requested axis.

Reindexing / selection / label manipulation

DataFrame.drop Drop specified labels from rows or columns.
DataFrame.head Return the first n rows.
DataFrame.rename Alter axes labels.
DataFrame.resetIndex Reset the index of a DataFrame
DataFrame.sample Return a random sample of items from an axis of object.
DataFrame.setIndex Set the DataFrame index using existing columns.
DataFrame.tail Return the last n rows.

Missing data handling

DataFrame.dropNa Remove missing values.
DataFrame.fillNa Fill NaN values with specified values
DataFrame.isNa Detect missing values.
DataFrame.replace Replace values given in replace with value.

Sorting & transposing

DataFrame.sortVlues Sort by the values along either axis.
DataFrame.T Return transpose of DataFrame

Combining / comparing / joining / merging

DataFrame.addColumn Add new columns to a DataFrame.
DataFrame.concat Concatenate DataFrames together.
DataFrame.merge Merge DataFrame or named Series objects with a database-style join.

Plotting

Series.plot is both a callable method and a namespace attribute for specific plotting methods of the form Series.plot.<kind>.

DataFrame.plot.bar Vertical bar plot.
DataFrame.plot.box Make a box plot of the DataFrame columns.
DataFrame.plot.violin Make a violin plot of the DataFrame columns.
DataFrame.plot.hist Draw one histogram of the DataFrame’s columns.
DataFrame.plot.scatter Generate Kernel Density Estimate plot using Gaussian kernels.
DataFrame.plot.line Plot Series or DataFrame as lines.
DataFrame.plot.pie Generate a pie plot.
Timeseries Plots Time series plots
Table Display Series as Interactive table in Div

Serialization / IO / conversion

DataFrame.toCSV Convert DataFrame to a CSV file.
DataFrame.toJSON Convert the object to a JSON.
[`DataFrame.toExcel`](../input-output/danfo.to\_excel.md) Convert DataFrame to Excel file