This script makes it possible to parse xml feeds and return a dataframe - it includes the following steps:
- with the help of the
requests library
, I'm able to connect to a web page - then I use
json
andxmltodict
libraries to transformcollections.OrderedDict
object into a dictionary - after that I construct a list by looping through dictionary keys to get the information I need
- when the list is ready, I use
pd.sjon_normalize
to create a dataframe - then the dataframe is sent to Google Spreadsheets via the
df2gspread
library