PinnedLoading

1. NASA-Data-WarehouseNASA-Data-WarehousePublic

   Pulls data from NASA DONKI API, and stages data in S3 to load to Redshift using boto3

   Python 6 3

2. Excel-Python-SQL-MigrationExcel-Python-SQL-MigrationPublic

   Migrates hundreds of Excel files with the same format to SQL using Python

   Python 5 2

3. Beatles-BopsBeatles-BopsPublic

   Builds an ETL pipeline of album information by The Beatles using the Spotify API, and loads to PostGreSQL

   Python 1

4. COVID-19-ProjectCOVID-19-ProjectPublic

   Processes Johns Hopkins University COVID-19 data to create a dashboard.

   Python 1

5. AnimalCrossing_PopularityDataAnimalCrossing_PopularityDataPublic

   Scrapes data on Animal Crossing villager popularity, joins to Kaggle table of villager traits, and appends to MySQL table using a CRON job.

   Python 3 3

6. Consumer-ComplaintsConsumer-ComplaintsPublic

   Reads consumer complaints csv file and provides the financial product and year, the total number of complaints, number of companies receiving a complaint, and the highest percentage of complaints d…

   Python