Python Pandas – 计算 DataFrame 中的行和列
要计算DataFrame中的行和列，请使用shape属性。首先，假设我们在桌面上有一个CSV文件，如下面的路径所示-
C:\\Users\\amit_\\Desktop\\CarRecords.csv
阅读CSV文件-
dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\CarRecords.csv")现在让我们使用形状计算行和列
dataFrame.shape
示例
以下是代码-
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)
#返回前5行记录
print("\nDataFrame with specific number of rows...\n",dataFrame.head(5))输出结果这将产生以下输出-
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 column in our DataFrame = (9, 3)
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