Often we come across a situation where we receive files from various sources as CSV files but with slightly changed column names or missing columns. Curating these files before loading to the database will be hectic if it is done manually. Here is a simple code in python which helps to read through a set of files in a source folder and do some basic cleaning in the field names and then match with standard fields to finally form a curated file.
Google Sheets is an excellent tool for storing and managing data, and it can be particularly useful when dealing with data in CSV format. CSV (Comma Separated Values) files are a common format for data exchange and can be easily exported from many applications. However, once you have your data in a CSV file, it can be cumbersome to work with and analyze. In this blog, we will explore how to import CSV data into Google Sheets using Python.