要选择包含特定文本的行,请使用contains()方法。假设以下是我们的 CSV 文件路径 -
C:\\Users\\amit_\\Desktop\\SalesRecords.csv
首先,让我们读取 CSV 文件并创建 Pandas DataFrame -
dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\CarRecords.csv")
现在,让我们选择包含特定文本“BMW”的行 -
dataFrame = dataFrame[dataFrame['Car'].str.contains('BMW')]
以下是代码 -
import pandas as pd # reading csv file dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\CarRecords.csv") print("DataFrame...\n",dataFrame) # select rows containing text "BMW" dataFrame = dataFrame[dataFrame['Car'].str.contains('BMW')] print("\nFetching rows with text BMW ...\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 BMW ... Car Place UnitsSold 3 BMW Delhi 95