Python - 查找 Pandas DataFrame 的统计信息摘要
要查找DataFrame的统计信息摘要,请使用describe()方法。首先,我们导入了以下带有别名的pandas库
import pandas as pd
以下是我们的CSV文件,我们正在创建一个PandasDataFrame-
dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\CarRecords.csv")现在,获取我们的PandasDataFrame的统计摘要-
dataFrame.describe()
示例
以下是完整代码
import pandas as pd
#读取csv文件
dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\CarRecords.csv")
print("DataFrame...\n",dataFrame)
#计算DataFrame中的行和列
print("\nNumber of rows and column in our DataFrame = ",dataFrame.shape)
#数据框摘要
print("\nGet the summary of statistics of a DataFrame = \n",dataFrame.describe())
#返回前7行记录
print("\nDataFrame with specific number of rows...\n",dataFrame.head(7))输出结果这将产生以下输出
DataFrame...
Car Place UnitsSold
0 Audi Bangalore 80
1 Porsche Mumbai 110
2 RollsRoyce Pune 100
3 BMW Delhi 95
4 Mercedes Hyderabad 80
5 Lamborghini Chandigarh 80
6 Audi Mumbai 100
7 Mercedes Pune 120
8 Lamborghini Delhi 100
Number of rows and colums in our DataFrame = (9, 3)
Get the summarry of statistics of a DataFrame =
UnitsSold
count 9.000000
mean 96.111111
std 14.092945
min 80.000000
25% 80.000000
50% 100.000000
75% 100.000000
max 120.000000
DataFrame with specific number of rows ...
Car Place UnitsSold
0 Audi Bangalore 80
1 Porsche Mumbai 110
2 RollsRoyce Pune 100
3 BMW Delhi 95
4 Mercedes Hyderabad 80
5 Lamborghini Chandigarh 80
6 Audi Mumbai 100热门推荐
1 如何训练狗狗不叫
2 训练狗狗不叫
3 训练狗狗随行
4 怎么训练狗狗不叫
7 训练比熊狗狗教程
10 上海狗狗训练
11 怎么训练狗狗上厕所
12 训练狗狗趴下
13 狗狗服从训练
14 训练狗狗拒食
15 训练狗狗笑
16 训练狗狗大便
17 训练狗狗立
18 训练狗狗捡东西