Python Dataframes: Describing a single column

python dataframe describe
Gitliong picture Gitliong · May 4, 2018 · Viewed 42.3k times · Source

Is there a way I can apply df.describe() to just an isolated column in a DataFrame.

For example if I have several columns and I use df.describe() - it returns and describes all the columns. From research, I understand I can add the following:

"A list-like of dtypes : Limits the results to the provided data types. To limit the result to numeric types submit numpy.number. To limit it instead to object columns submit the numpy.object data type. Strings can also be used in the style of select_dtypes (e.g. df.describe(include=['O'])). To select pandas categorical columns, use 'category'"

However I don't quite know how to write this out in python code. Thanks in advance.

Answer

ma-ku picture ma-ku · May 10, 2018

Just add column name in square braquets:

df['column_name'].describe()

Example:

enter image description here

To get a single column:

df['1']

To get several columns:

df[['1','2']]

To get a single row by name:

df.loc['B']

or by index:

df.iloc[o]

To get a specific field:

df['1']['C']

Related questions

How to describe columns as categorical values?

I have a pandas dataframe that contains a mix of categorical and numeric columns. By default, df.describe() returns only a summary of the numerical data (describing those columns with count, mean, std, min, quantiles, max) when iterating through all …

Read More
How to select rows from a DataFrame based on column values

How can I select rows from a DataFrame based on values in some column in Pandas? In SQL, I would use: SELECT * FROM table WHERE colume_name = some_value I tried to look at Pandas' documentation, but I did not …

Read More
Renaming columns in pandas

I have a DataFrame using pandas and column labels that I need to edit to replace the original column labels. I'd like to change the column names in a DataFrame A where the original column names are: ['$a', '$…

Read More