Python Coding for excel data bases
Budget: $30 – $250 USD
To complete this task , you will be working with the attached database:
This file includes all the shipments in different years in the US.
For this assignment, you will use the given the attached datasetto perform a complete economic and business analysis of the dataset.
Your analysis should include at least the following:
1- Total shipments per state
2- Top five states in terms of bill
3- Total shipments per state and year
4- Number of different postal codes
After this, you must include six to ten additional insights you want to highlight based on an analysis performed using Python.
Deliverable: Two documents.
1 - A PDF file with the complete analysis. This file must be a report for your manager with your business analysis. Please explain all of your insights. Do not include code or Python commands in this document.
2 - A Python or .txt file with all the commands you used for this activity. You must include comments inside the Python file to demonstrate that you understood the commands applied.
This file includes all the shipments in different years in the US.
For this assignment, you will use the given the attached datasetto perform a complete economic and business analysis of the dataset.
Your analysis should include at least the following:
1- Total shipments per state
2- Top five states in terms of bill
3- Total shipments per state and year
4- Number of different postal codes
After this, you must include six to ten additional insights you want to highlight based on an analysis performed using Python.
Deliverable: Two documents.
1 - A PDF file with the complete analysis. This file must be a report for your manager with your business analysis. Please explain all of your insights. Do not include code or Python commands in this document.
2 - A Python or .txt file with all the commands you used for this activity. You must include comments inside the Python file to demonstrate that you understood the commands applied.