You are provided with the following datasets:
Your task is to combine these datasets into one complete dataset using pandas. Follow these steps:
Fix Column Names: Use the correct column names from the instructions to rename the columns in Sub Dataset 1.
Fill Missing Rows: Identify the missing rows in Sub Dataset 2 and fill them using the corresponding rows from Sub Dataset 3.
Fix Missing Data Values: Locate the missing values in Sub Dataset 3 and replace them using data from Sub Dataset 2 where available.
Combine Datasets: Merge all the corrected sub-datasets to create a single complete dataset.
Validate the Final Dataset: Ensure the final dataset has no missing column names, rows, or values.
Expected Final Dataset: original_dataset.csv (do no use this dataset in your code and this needs to be derived using the above source files and this is attached just for reference on how the data output to be displayed using pandas in python )
Once completed, analyze the final dataset to confirm accuracy and completeness
Need ipynb file with the code used to drive the output dataset and the a word document with the descriptions related to steps followed to derive the output
