1
2
| import requests
import pandas as pd
|
Using the amazon price api from rapidapi.com
1
| url = "https://amazon-price1.p.rapidapi.com/search"
|
Here, I am querying a bottom bracket used for replacing on my bicycle
1
2
3
4
5
6
7
8
9
10
| querystring = {"keywords":"bottom bracket","marketplace":"ES"}
headers = {
"X-RapidAPI-Key": "hidden here",
"X-RapidAPI-Host": "amazon-price1.p.rapidapi.com"
}
response = requests.request("GET", url, headers=headers, params=querystring)
print(response.text)
|
Store the result in panda format
1
| df = pd.read_json(response.text)
|
|
ASIN |
title |
price |
listPrice |
imageUrl |
detailPageURL |
rating |
totalReviews |
subtitle |
isPrimeEligible |
| 0 |
B005L83TF4 |
SUN RACE BBS15 Bottom Bracket 68/127MM-STEEL E... |
13,14 € |
|
https://m.media-amazon.com/images/I/316upP-m6I... |
https://www.amazon.es/dp/B005L83TF4 |
3.8 |
33 |
|
0 |
| 1 |
B006RM70JY |
The Bottom Bracket (English Edition) |
2,99 € |
|
https://m.media-amazon.com/images/I/411tM3tvfN... |
https://www.amazon.es/dp/B006RM70JY |
4.5 |
2 |
|
0 |
| 2 |
B075GQJFL1 |
Bottom Bracket |
0,99 € |
|
https://m.media-amazon.com/images/I/71jDB9f3AK... |
https://www.amazon.es/dp/B075GQJFL1 |
|
|
|
0 |
| 3 |
B075DW91K2 |
Bottom Bracket |
0,99 € |
|
https://m.media-amazon.com/images/I/71Tr4XpGvd... |
https://www.amazon.es/dp/B075DW91K2 |
|
|
|
0 |
| 4 |
B09D8S31V7 |
Bottom Bracket Racket |
1,29 € |
|
https://m.media-amazon.com/images/I/41qG7oY5Ky... |
https://www.amazon.es/dp/B09D8S31V7 |
|
|
|
0 |
| 5 |
B08K2WHFS2 |
Dandy in the Underworld |
1,29 € |
|
https://m.media-amazon.com/images/I/51UcKxQdUn... |
https://www.amazon.es/dp/B08K2WHFS2 |
|
|
|
0 |
| 6 |
B08K2VYJFK |
Dandy in the Underworld |
1,29 € |
|
https://m.media-amazon.com/images/I/51UcKxQdUn... |
https://www.amazon.es/dp/B08K2VYJFK |
|
|
|
0 |
| 7 |
B01J5083XQ |
Solstice |
0,99 € |
|
https://m.media-amazon.com/images/I/51avvd1duQ... |
https://www.amazon.es/dp/B01J5083XQ |
|
|
|
0 |
| 8 |
B01J5082CS |
Solstice |
0,99 € |
|
https://m.media-amazon.com/images/I/51avvd1duQ... |
https://www.amazon.es/dp/B01J5082CS |
|
|
|
0 |
| 9 |
B09J781T8V |
Soporte Inferior, Bottom Bracket, Token Ninja ... |
74,01 € |
|
https://m.media-amazon.com/images/I/312Gc5vg36... |
https://www.amazon.es/dp/B09J781T8V |
5.0 |
1 |
|
0 |