英文:
Get Amazon reviews in a csv file via Python and AWS
问题
这是我的实际代码，但我无法连接到数据库（我不理解，也找不到如何配置AWS的文档）。我收到了错误410。
寻找指南和建议。谢谢。
英文:
Here is my actual code but I can't get through the data base (I don't understand and didn't find documentation how to configure AWS). I got error 410.
Just looking for guide and advices. Thanks.
import bottlenose
import boto3
from bs4 import BeautifulSoup
import pandas as pd
AWS_ACCESS_KEY_ID = '146h760vij'
AWS_SECRET_ACCESS_KEY = 'gikbTElBmA6BexZt8eWKF23apWBbY5fx3Uj2Fpxr'
AWS_ASSOCIATE_TAG = 'testest'
amazon = bottlenose.Amazon(AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_ASSOCIATE_TAG)
def get_product_reviews(asin):
reviews_data = []
try:
response = amazon.ItemLookup(ItemId=asin, ResponseGroup='Reviews', TruncateReviewsAt=1000)
soup = BeautifulSoup(response, 'xml')
reviews = soup.find_all('Review')
for review in reviews:
review_id = review.ReviewId.text
rating = review.OverallRating.text
review_text = review.Content.text
reviews_data.append({
'Review ID': review_id,
'Rating': rating,
'Review Text': review_text
})
except Exception as e:
print("An error occurred during the API request:", e)
return reviews_data
asin = 'B09N9JKM8S'
reviews = get_product_reviews(asin)
df = pd.DataFrame(reviews)
df.to_csv('reviews.csv', index=False)
</details>
# 答案1
**得分**: 1
错误410表示给定ASIN的产品不再可用或不存在于Amazon产品广告API中。因此，首先，您应该验证您使用的ASIN是否正确，并且仍然存在于Amazon上。
在配置AWS方面，您需要设置您的AWS凭据和关联标签在您的AWS账户中。以下是您可以执行的步骤：
1. 如果尚未创建AWS账户，请先创建一个AWS账户。
2. 登录到AWS管理控制台。
3. 转到IAM仪表板并创建一个新的具有程序访问权限的IAM用户。
4. 给IAM用户授予访问Amazon产品广告API所需的权限。
5. 记下IAM用户的访问密钥ID和秘密访问密钥。
6. 通过注册Amazon联盟计划来设置一个关联标签。
7. 在您的Python代码中使用访问密钥ID、秘密访问密钥和关联标签进行API调用。
您需要使用boto3包来配置AWS凭据并进行API调用。以下是如何使用boto3配置AWS凭据的示例：
```python
import boto3
AWS_ACCESS_KEY_ID = 'your_access_key_id'
AWS_SECRET_ACCESS_KEY = 'your_secret_access_key'
session = boto3.Session(
aws_access_key_id=AWS_ACCESS_KEY_ID,
aws_secret_access_key=AWS_SECRET_ACCESS_KEY,
region_name='us-west-2' # 替换为适用于您用例的适当地区
)
# 为Amazon产品广告API创建客户端
amazon = session.client('sqs')
将your_access_key_id和your_secret_access_key替换为您的实际AWS凭据。此外，根据您的用例，将'us-west-2'替换为适当的地区。您可以在AWS文档中找到可用地区的列表。
英文:
Error 410 indicates that the product with the given ASIN is no longer available or does not exist in the Amazon Product Advertising API. So firstly, you should verify that the ASIN you are using is correct and still exists on Amazon.
In terms of configuring AWS, you will need to set up your AWS credentials and associate tag in your AWS account. Here's how you can do it:
- Create an AWS account if you haven't already done so.
- Log in to the AWS Management Console.
- Go to the IAM dashboard and create a new IAM user with programmatic
access. - Give the IAM user the necessary permissions to access the Amazon
Product Advertising API. - Take note of the Access Key ID and Secret Access Key for the IAM
user. - Set up an Associate Tag by signing up for the Amazon Associates
program. - Use the Access Key ID, Secret Access Key, and Associate Tag in your
Python code to make API calls.
You will need to use the boto3 package to configure AWS credentials and make API calls. Here's an example of how to configure AWS credentials using boto3:
import boto3
AWS_ACCESS_KEY_ID = 'your_access_key_id'
AWS_SECRET_ACCESS_KEY = 'your_secret_access_key'
session = boto3.Session(
aws_access_key_id=AWS_ACCESS_KEY_ID,
aws_secret_access_key=AWS_SECRET_ACCESS_KEY,
region_name='us-west-2' # replace with the appropriate region
)
# create a client for the Amazon Product Advertising API
amazon = session.client('sqs')
Replace your_access_key_id and your_secret_access_key with your actual AWS credentials. Also, replace 'us-west-2' with the appropriate region for your use case. You can find a list of available regions in the AWS documentation.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论