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
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...
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F84d680ae-8aba-47df-b8e3-74db78a7526b%2F64653fbe-5121-4767-8a2c-a50a8f9c25c7%2Fw6p8ff_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY