过滤行——Python Pandas
要过滤行并获取特定的列值，请使用Pandascontains()方法。首先，让我们使用别名导入所需的库-
import pandas as pd
使用.csv文件读取CSV文件read_csv()。我们的CSV文件在桌面上-
dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\CarRecords.csv")现在，让我们过滤具有特定文本的行-
dataFrame = dataFrame[dataFrame['Car'].str.contains('Lamborghini')]示例
以下是代码
import pandas as pd
#readingcsvfile
dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\CarRecords.csv")
print("DataFrame...\n",dataFrame)
# select rows containing text "Lamborghini"
dataFrame = dataFrame[dataFrame['Car'].str.contains('Lamborghini')]
print("\nFetching rows with text Lamborghini ...\n",dataFrame)输出结果这将产生以下输出-
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
Fetching rows with text Lamborghini ...
Car Place UnitsSold
5 Lamborghini Chandigarh 80
8 Lamborghini Delhi 100