import pandas as pd
amazon = pd.read_csv(r"C:\Users\User\Desktop\archive\amazon.csv")
amazon.head()
ASIN | Category | Product Link | No of Sellers | Rank | Rating | Reviews Count | Price | |
---|---|---|---|---|---|---|---|---|
0 | B079QHML21 | Electronics | https://www.amazon.com/gp/offer-listing/B079QH... | 1 Sellers | #1 | 4.7 | 640,721 | $39.99 |
1 | B07FZ8S74R | Electronics | https://www.amazon.com/gp/offer-listing/B07FZ8... | 1 Sellers | #2 | 4.7 | 854,114 | $34.99 |
2 | B07XJ8C8F5 | Electronics | https://www.amazon.com/gp/offer-listing/B07XJ8... | 1 Sellers | #3 | 4.7 | 267,821 | $44.99 |
3 | B07WVFCVJN | Electronics | https://www.amazon.com/gp/offer-listing/B07WVF... | 27 Sellers | #4 | 4.8 | 114,267 | $28.48 |
4 | B08YT2N5SX | Electronics | https://www.amazon.com/gp/offer-listing/B08YT2... | 1 Sellers | #5 | 4.7 | 267,821 | $49.99 |