Answered step by step
Verified Expert Solution
Question
1 Approved Answer
To do the following project, you must use the file called borderCrossing.csv. Do NOT convert the file to an excel format, you will receive a
To do the following project, you must use the file called borderCrossing.csv. Do NOT convert the file to an excel format, you will receive a ZERO if you do not read the data from a csv file. Write a program to do the following: . Read the data from the borderCrossing.csv file. Under the Border column, change the following data: o "US-Canada Border to Canadian" US-Mexico Border" to "Mexican" Under the Measure column, change the following data: "Rail Containers Empty" and "Rail Containers Full" to "Rail Containers." Truck Containers Empty" and "Truck Containers Full to Truck Containers" Once you've changed the data in the two columns above, create an Excel file named "BorderCrossingClean.xlsx". Only copy the data from the following columns in the order below: o Border o Port Name O State o Date 0 Measure O Value Please note that you will NOT be copying the Port Code and the Location columns. For full credit, you must include your header in your python file, including the create date and your name! Save the program as a *py file and upload the both the python file and your Excel file (BorderCrossingClean.xlsx) to blackboard
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started