A simple spider program using the Scrapy framework in python. This spider program scrapes the first 10 pages of the 'English Books' section in Amazon.in. It stores the book names and the respective authors in a mySQL table.
1] Open the project folder in pycharm/any other IDE.
2] Setup mySQL if not done.
3] Open Terminal
>> cd <project directory>
>> scrapy crawl spider1
4] Restart mySQL. The contents should be visible in a newly created table.