How to Select Data Reside in Column Above or Below or Equal to a Specified Value In Pandas

How to Select Data Reside in Column Above or Below or Equal to a Specified Value In Pandas

How to Select Data Reside in Column Above or Below or Equal to a Specified Value In Pandas

 

There is a set of CSV Data  amazon .csv. Inside this set of data , there is a column  ‘Rating ” .We would like to print out all Rows and Columns of the Data if the Rating value is above 4.7.

The code will perform the task listed below

(1)import pandas library

(2)Turn CSV into Dataframe

(3) Print First 5 row of the Amazon_0  Dataframe

(4) Select the rating Column from Amazon_0 and assign to amazon_rate

(5) Boolean Check Amazon _rate  data , rating which are  more than 4.7 and save the Result into amzon_48

(7) Pass amazon_48as a parameter into Amazon_0

(8) Create a new DataFrame and Print out the Results of Rating  > 4.7 in full Column and rows

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

5 + three =