import pandas as pd
amazon_0 = pd.read_csv(r"C:\Users\User\Desktop\archive\amazon.csv",index_col=0)
amazon_0.head()
Category | Product Link | No of Sellers | Rank | Rating | Reviews Count | Price | |
---|---|---|---|---|---|---|---|
ASIN | |||||||
B079QHML21 | Electronics | https://www.amazon.com/gp/offer-listing/B079QH... | 1 Sellers | #1 | 4.7 | 640,721 | $39.99 |
B07FZ8S74R | Electronics | https://www.amazon.com/gp/offer-listing/B07FZ8... | 1 Sellers | #2 | 4.7 | 854,114 | $34.99 |
B07XJ8C8F5 | Electronics | https://www.amazon.com/gp/offer-listing/B07XJ8... | 1 Sellers | #3 | 4.7 | 267,821 | $44.99 |
B07WVFCVJN | Electronics | https://www.amazon.com/gp/offer-listing/B07WVF... | 27 Sellers | #4 | 4.8 | 114,267 | $28.48 |
B08YT2N5SX | Electronics | https://www.amazon.com/gp/offer-listing/B08YT2... | 1 Sellers | #5 | 4.7 | 267,821 | $49.99 |
amazon_rate = amazon_0['Rating']
amazon_rate
ASIN B079QHML21 4.7 B07FZ8S74R 4.7 B07XJ8C8F5 4.7 B07WVFCVJN 4.8 B08YT2N5SX 4.7 ... B007DW6F34 4.6 B01N16VX79 4.7 B09197N995 4.8 B015CCR1FW 4.7 B07TS96J7Q 4.7 Name: Rating, Length: 707, dtype: float64
amazon_48 = amazon_rate >4.7
amazon_48
ASIN B079QHML21 False B07FZ8S74R False B07XJ8C8F5 False B07WVFCVJN True B08YT2N5SX False ... B007DW6F34 False B01N16VX79 False B09197N995 True B015CCR1FW False B07TS96J7Q False Name: Rating, Length: 707, dtype: bool
amazon48Data=pd.DataFrame(amazon_0[amazon_48])
amazon48Data
Category | Product Link | No of Sellers | Rank | Rating | Reviews Count | Price | |
---|---|---|---|---|---|---|---|
ASIN | |||||||
B07WVFCVJN | Electronics | https://www.amazon.com/gp/offer-listing/B07WVF... | 27 Sellers | #4 | 4.8 | 114,267 | $28.48 |
B00EB4ADQW | Electronics | https://www.amazon.com/gp/offer-listing/B00EB4... | 32 Sellers | #19 | 4.8 | 59,785 | $13.22 |
B00DOMYL24 | Electronics | https://www.amazon.com/gp/offer-listing/B00DOM... | 19 Sellers | #32 | 4.8 | 44,320 | $12.75 |
B015IY34FA | Electronics | https://www.amazon.com/gp/offer-listing/B015IY... | 19 Sellers | #41 | 4.8 | 38,743 | $37.09 |
B08J61NFNR | Electronics | https://www.amazon.com/gp/offer-listing/B08J61... | 6 Sellers | #47 | 4.9 | 44,087 | $395.00 |
... | ... | ... | ... | ... | ... | ... | ... |
B07P6RFKRL | Toys & Games | https://www.amazon.com/gp/offer-listing/B07P6R... | 15 Sellers | #89 | 4.8 | 17,537 | $14.95 |
B01BX4G6FY | Toys & Games | https://www.amazon.com/gp/offer-listing/B01BX4... | 19 Sellers | #91 | 4.8 | 14,866 | $22.18 |
B08XN821N5 | Toys & Games | https://www.amazon.com/gp/offer-listing/B08XN8... | 1 Sellers | #93 | 4.8 | 18,647 | $9.98 |
B00000IZJB | Toys & Games | https://www.amazon.com/gp/offer-listing/B00000... | 56 Sellers | #94 | 4.8 | 22,385 | $14.97 |
B09197N995 | Toys & Games | https://www.amazon.com/gp/offer-listing/B09197... | 1 Sellers | #97 | 4.8 | 9,121 | $8.99 |
231 rows × 7 columns