Google Colab notebook: Python for loop -> Pandas dataframe -> csv

Job ID: 34911085

Budget: $10 – $30 USD

I need a Jupyter Notebook (preferably a Google Colab notebook) that features the following data flow:

Python 'for loop' feeds list of urls for .fec files
FastFEC parses these files, pulling the header summaries from each
Header for each appended to a Pandas dataframe
Once feed is complete, dataframe exported as csv (or Google sheet)

More information:
Google Colab: https://colab.research.google.com/
Example of list attached
Example start of 'for loop':
for f in files:
....subprocess.run([f"curl -s 'https://docquery.fec.gov/dcdev/posted/{f}.fec'...
Use FastFEC (https://www.washingtonpost.com/fastfec/) to parse those files (pip install fastfec)
Pull just the headers of each, add first column with the filing_id number from list used as 'f' variable above (see attached sample)
Write into Pandas (https://pandas.pydata.org/docs/) dataframe
Print/export resulting dataframe to csv. It should have something like 650 rows.

Tips: In case you aren't too familiar with Google Colab/iPython Notebooks, you can run terminal operations by leading with an exclamation mark. So the install of FastFEC, for example, would be this notebook cell:
!pip install fastfec
Related categories: Python Pandas