Python Dataframes: Describing a single column

2019-06-24 02:44发布

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.

2条回答
你好瞎i
2楼-- · 2019-06-24 03:31

Just add column name in square braquets:

df['column_name'].describe()

Example:

enter image description here

To get single column:

df['1']

To get few column:

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

To get single row:

df.loc['B'] by row name or df.iloc[o] by index.

To get precised field:

df['1']['C']

查看更多
放我归山
3楼-- · 2019-06-24 03:32
import pandas as pd
data = pd.read_csv("ad.data", header=None)
data[111].describe()

or for example

lastindice = data[data .columns[-1]]
lastindice.describe()
查看更多
登录 后发表回答