I have included a brief of what i need to do for a coding project using python in jupyter notebook. We have been given a cvs file in jupyter notebook with data of missing animals in london layed out like this: Count of Stolen Animals,Type of Animal,Borough,Type Of Offence,Animal Recovered,Year and Month 1,Dog,Lambeth,Theft and Handling,Not Recovered,Jan-2010 1,Dog,Islington,Violence Against the Person,Not Recovered,Jan-2010 1,Dog,Croydon,Robbery,Not Recovered,Jan-2010   any help on how to do this would be great

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%

I have included a brief of what i need to do for a coding project using python in jupyter notebook. We have been given a cvs file in jupyter notebook with data of missing animals in london layed out like this:

Count of Stolen Animals,Type of Animal,Borough,Type Of Offence,Animal Recovered,Year and Month
1,Dog,Lambeth,Theft and Handling,Not Recovered,Jan-2010
1,Dog,Islington,Violence Against the Person,Not Recovered,Jan-2010
1,Dog,Croydon,Robbery,Not Recovered,Jan-2010
 
any help on how to do this would be great 
read_file
The following specifications should be met for your code solution:
• The specified function name must be used
• The function will take a single argument called filename. This will allow the
function to be called for different data files of this same format.
• The function should read in the CsV file and unpack the information contained
into variables with an appropriate type.
o The column headings (e.g. Count of Stolen Animals, etc.) should be
stored in a list, with one element per column heading
o The number of stolen animals should be returned as a list of integers
o The other column data should be returned as lists of strings. One list
per column
The function should return the processed data with the following order for the
return arguments:
o The column headings list
o The data columns: col1, col2, ..., col6
Transcribed Image Text:read_file The following specifications should be met for your code solution: • The specified function name must be used • The function will take a single argument called filename. This will allow the function to be called for different data files of this same format. • The function should read in the CsV file and unpack the information contained into variables with an appropriate type. o The column headings (e.g. Count of Stolen Animals, etc.) should be stored in a list, with one element per column heading o The number of stolen animals should be returned as a list of integers o The other column data should be returned as lists of strings. One list per column The function should return the processed data with the following order for the return arguments: o The column headings list o The data columns: col1, col2, ..., col6
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Hi there Thankyou for the answer, How do I read the data in as I tried this and then put in the code you've written above and nothing has happened ( doesn't come up with a syntax error just nothing happens when I run it)

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY