Question: The table shown below is an example of a messy data set that does not conform to Hadley Wickham's Tidy Data principles. The table contains

The table shown below is an example of a "messy" data set that does not conform to Hadley Wickham's Tidy Data principles. The table contains information regarding the volume of imports and exports for each of the first three months of 2019,2020,2021. Trade volumes for goods and services are tracked separately within the table.
\table[[,,2019,2020,2021],[January,,,,],[Exports,Goods,131,228,85,019,561,389],[,Services,56,883,220,441,76,130],[,,,,],[Imports,Goods,191,745,4,200,498,762],[,Services,284,195,146,332,223],[,,,,],[February,,,,],[Exports,Goods,135,783,167,009,689,123],[,Services,127,419,124,981,820,912],[,,,,],[Imports,Goods,146,983,189,422,897,141],[,Services,117,551,155,733,678,134],[,,,,],[March,,,,],[Exports,Goods,369,121,212,455,478,312],[,Services,151,821,99,876,578,134],[,,,,],[Imports,Goods,242,730,189,509,319,034],[,Services,84,111,178,223,210,780]]
Provide a narrative explaining the ways in which the table does not conform to Tidy Data guidelines: Your narrative MUST provide specific examples from the table shown above and not merely refer to generic Tidy Data guidelines.Then, having specified the Tidy Data deficiencies you believe to be present within the table,
provide Python code that transforms the table into a Tidy "long" format and provide a
screenshot of the output of your Python code.
NOTE: To facilitate your Python work for this problem, a CSV file containing the table showr
above can be downloaded here: )
To get started, Use the pd.read_csv() function to read the CSV file from your GitHub
repository into your Python environment WITHOUT removing any empty rows or columns
from the content of the file. The content of the resulting dataframe should appear as shown
below. Your Python code MUST use the contents of this dataframe as the basis of the
work you choose to do to transform the table into a Tidy "long" format.
Your code + screenshot of your output should be submitted via the provided textbox. )
NOT submit a Jupyter Notebook, .py file, or HTML file. DO NOT submit a
screenshot of your code; your code MUST be submitted as text that can be
easily copied/executed. Failure to submit the code properly will preclude you
from receiving any credit for this problem.i want python code for this. this is data acquisition and management subject
The table shown below is an example of a "messy"

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!