Curating 'CSV' files with JSON metadata Using Python
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.