The client's problem was that their business regularly produces unformatted Google Sheets spreadsheets that logged the trips taken by airport shuttle taxis from two airports in a major metropolitan area. They'd developed a color-coded organized format they wanted the sheets in and came to me. I implemented a GCP program that could automatically reformat their sheets and do some data cleaning in the process. I wrote a program that would download a given sheet, clean it, reformat it, colorize it, and then upload a new modified sheet.
Built with
- pandas
- API Integration
- Google Cloud Platform
- Google Sheets
- Python