I am new to programming and learned a little bit of Python in the previous two weeks and wrote an automation script that scrapes Categories and articles in each category from a website. Now I want to test that script on my WordPress blog and post articles in their respective categories in the WordPress blog. Can someone direct me to any thorough guide to executing this process? I have done some research on this but there is very little information available on the internet.
The best way is to write a php code (in your site) where you will upload the json file. the script will then save data to your database .Modify the  python script to save the scraped data in json(many languages easily support it + has more usage and is faster) then upload it to the php file.From database you can display your data
Can I post Python scraped articles to my wordpress site using XML-RPC?