Hexo

import requests
import pandas as pd

Using the amazon price api from rapidapi.com

url = "https://amazon-price1.p.rapidapi.com/search"

Here, I am querying a bottom bracket used for replacing on my bicycle

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

df = pd.read_json(response.text)

df

	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