Unified Census Data Consolidation
Budget: $30 – $250 USD
I have more than twenty-one separate census workbooks that need to become one clean, analysis-ready master table. All source files are in Excel, but only a portion share the same column order, header names, and data types—others drift just enough that simple copy-paste won’t work.
Here is what I need from you:
• Inspect every workbook, standardise field names, data types, and date formats
• Append all records into one master sheet (or a single .xlsx with a clearly named “Master” tab)
• Flag and resolve duplication, obvious entry errors, and encoding issues
• Deliver a concise data dictionary so I can see how each original column mapped into the final table
Accuracy matters more than speed; however, once the structure rules are locked, I’d like an efficient, repeatable import method (Power Query, Python pandas, or similar) so future files can drop straight in.
Final hand-off: the consolidated master table, the documented transformation logic, and any helper scripts or queries you used, packaged so I can rerun the process myself if new census batches arrive.
Here is what I need from you:
• Inspect every workbook, standardise field names, data types, and date formats
• Append all records into one master sheet (or a single .xlsx with a clearly named “Master” tab)
• Flag and resolve duplication, obvious entry errors, and encoding issues
• Deliver a concise data dictionary so I can see how each original column mapped into the final table
Accuracy matters more than speed; however, once the structure rules are locked, I’d like an efficient, repeatable import method (Power Query, Python pandas, or similar) so future files can drop straight in.
Final hand-off: the consolidated master table, the documented transformation logic, and any helper scripts or queries you used, packaged so I can rerun the process myself if new census batches arrive.
Related categories:
Python
Data Processing
Excel
Data Mining
Data Cleansing
Data Analysis
Data Integration
Data Management