Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

demonstrate the importance of induction training.

Answered: 1 week ago