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