Python Pandas - Read data from a CSV file and print the ‘product’ column value that matches ‘Car’ for the first ten rows

Assume, you have ‘products.csv’ file and the result for a number of rows and columns and ‘product’ column value matches ‘Car’ for the first ten rows are −

Download the products.csv file here.

Rows: 100 Columns: 8
id    product    engine    avgmileage    price    height_mm    width_mm    productionYear
1 2    Car       Diesel       21         16500       1530          1735         2020
4 5    Car         Gas        18         17450       1530          1780         2018
5 6    Car         Gas        19         15250       1530          1790         2019
8 9    Car        Diesel      23         16925       1530          1800         2018

We have two different solutions for this problem.

Solution 1

• Read data from products.csv file and assign to df

df = pd.read_csv('products.csv ')

• Print the number of rows = df.shape[0] and columns = df.shape[1]

• Set df1 to filter first ten rows from df using iloc[0:10,:]

df1 = df.iloc[0:10,:]

• Calculate the product column values matches to the car using df1.iloc[:,1]

Here, the product column index is 1, and finally print the data

df1[df1.iloc[:,1]=='Car']

Example

Let’s check the following code to get a better understanding −

import pandas as pd
df = pd.read_csv('products.csv ')
print("Rows:",df.shape[0],"Columns:",df.shape[1])
df1 = df.iloc[0:10,:]
print(df1[df1.iloc[:,1]=='Car'])

Solution 2

• Read data from products.csv file and assign to df

df = pd.read_csv('products.csv ')

• Print the number of rows = df.shape[0] and columns = df.shape[1]

• Take first ten rows using df.head(10) and assign to df

df1 = df.head(10)

• Take product column values matches to Car using below method

df1[df1['product']=='Car']

Example

Now, let’s check its implementation to get a better understanding −

import pandas as pd
df = pd.read_csv('products.csv ')
print("Rows:",df.shape[0],"Columns:",df.shape[1])
df1 = df.head(10)
print(df1[df1['product']=='Car'])

Output

Rows: 100 Columns: 8
id    product    engine    avgmileage    price    height_mm    width_mm    productionYear
1 2    Car       Diesel       21         16500       1530          1735      2020
4 5    Car       Gas          18         17450       1530          1780      2018
5 6    Car       Gas          19         15250       1530          1790      2019
8 9    Car       Diesel       23         16925       1530          1800      2018

Vani Nalliappan

Published on 16-Feb-2021 08:50:29

• Related Questions & Answers
• Validate input: replace all ‘a’ with ‘@’ and ‘i’ with ‘!’JavaScript
• Python program to replace first ‘K’ elements by ‘N’
• Python Program to print the pattern ‘G’
• On inserting ‘NULL’, ‘0’ or No Value to the column, will MySQL assign sequence number for AUTO_INCREMENT column?
• Count of sub-strings that do not contain all the characters from the set {‘a’, ‘b’, ‘c’} at the same time in C++
• Learn Why ‘less’ is Faster Than ‘more’ Command for Effective File Navigation
• Are ‘this’ and ‘super’ keywords in Java?
• ‘AND’ vs ‘&&’ operators in PHP
• Write a program in Python to print the ‘A’ grade students’ names from a DataFrame
• What is the use of ‘ALL’, ‘ANY’, ’SOME’, ’IN’ operators with MySQL subquery?
• What is the benefit of MySQL ‘IS NULL’ and ‘IS NOT NULL’?
• In the query [SELECT column1, column2 FROM table_name WHERE condition; ] which clause among ‘SELECT’, ‘WHERE’ and ‘FROM’ is evaluated in the last by the database server and why?
• Increment column value ‘ADD’ with MySQL SET clause
• PHP program to find the sum of first n natural numbers that are divisible by a number ‘x’ or a number ‘y’
• Write a program in C++ to count the Number of substrings that starts with ‘1’ and ends with ‘1’