Question: Accesses the data stored in the file_data instance variable (a list) and converts it to a dictionary, data_dict, where each key is a column name

Accesses the data stored in the file_data instance variable (a list) and converts it to a dictionary, data_dict, where each key is a column name found in the CSV, and each value is a list of data in that column with the same order as it was in the file. Each element of the list corresponds to a single row in the CSV. For example, to access the Title column in the CSV, I would access data_dict[Title]. Accesses the data stored in the file_data instance variable (a list) and ^^^ this is the csv filed.

This is the code I have now (IN PYTHON). My error is that the list index is out of range and I have tried many things and not get how to fix this issue. The cvs has already been opened and read before this.

self.data_dict = {

'Title': [],

'Pages': [],

'URL': [],

'Author Name': [],

'Genre': [],

}

for i in range(len(self.file_data) + 1):

self.data_dict['Title'].append([i][0])

self.data_dict['Pages'].append([i][1])

self.data_dict['URL'].append([i][2])

self.data_dict['Author Name'].append([i][3])

self.data_dict['Genre'].append([i][-1])

1 2 3 4 5 6 7 8 9 10 11 12 13 Title, Pages, URL, Author Name, Genre The Book Thief,552, https://www.goodreads.com/book/show/19063, Markus Zusak, Historical Fiction The Hunger Games,374, https://www.goodreads.com/book/show/2767052, Suzanne Collins, Science Fiction Romeo and Juliet, 301, https://www.goodreads.com/book/show/18135, William Shakespeare, Romance To Kill a Mockingbird, 324, https://www.goodreads.com/book/show/2657, Harper Lee, Historical Fiction Pride and Prejudice, 279, https://www.goodreads.com/book/show/1885, Jane Austen, Historical Fiction Twilight, 501, https://www.goodreads.com/book/show/41865, Stephenie Meyer, Fantasy Animal Farm, 141, https://www.goodreads.com/book/show/170448, George Orwell, Science Fiction The Chronicles of Narnia, 767, https://www.goodreads.com/book/show/11127,C.S. Lewis, Fantasy The Fault in Our Stars, 313, https://www.goodreads.com/book/show/11870085, John Green, Romance Gone with the Wind, 1037, https://www.goodreads.com/book/show/18405, Margaret Mitchell, Historical Fiction The Alchemist, 182, https://www.goodreads.com/book/show/18144590, Paulo Coelho, Philosophy The Da Vinci Code, 489, https://www.goodreads.com/book/show/968, Dan Brown, Mystery Thriller The Picture of Dorian Gray, 272, https://www.goodreads.com/book/show/5297, Oscar Wilde, Horror Memoirs of a Geisha,503, https://www.goodreads.com/book/show/929, Arthur Golden, Historical Fiction Fahrenheit 451,194, https://www.goodreads.com/book/show/13079982, Ray Bradbury, Science Fiction Lord of the Flies, 182, https://www.goodreads.com/book/show/7624, William Golding, Science Fiction 14 15 16 17

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please help implement FileSystem.java using the BST structure. The FIleData class is here The BST.java is here, you don't need to implement it. You can use the methods in it. This is some...

CODE ALL OF TASK 1 HERE UNDER THE FILE NAME "property.py" class Property: def __init__(self, property_name: str, property_cost: int, hotel_cost: int, rent_price: int, colour_group: str) -> None:...

In this project you will complete the implementation of a Java program that helps a user maintain a library of their favorite songs. The library is in the form of a list of songs. The program stores...

Need help writing this java code that maintains a song list. I technically have the code written but I just need help rewriting it, also because uses txt files I don't need it to run just help...

I need to desing a code that will read a CSV file and perform the the 3 cases scenarios outlined in the following pictures. The CSV file can be accesed/downloaded in the last picture. Thank you in...

) Explain the term overloading in the context of Java constructors and methods. [2 marks] (b) Without describing the details of either, outline the relationship between the Java methods...

I need help with this lab assignment it must be in python Dave Jeffery will be at a conference on March 16, 2018. Class will meet in ARSC 124 at the normal time to work on Lab 9. Blackboard will...

Bookstore Project The Project (Statement of Required Work with hints) To simplify your behavior diagrams, separate them according to the forms you will use one set of diagrams for each form. Please...

Part 1: Date Arithmetic Operations date_arithmetic()-> Tuple[datetime, datetime,int] Date arithmetic is far more difficult than you might imagine. For example, what is the date three days after Feb...

This week's assignment will focus on the data structures you already know: the list and the dictionary, as well as reading and writing to text files. Since it's a bit challenging, we'll break it down...

Find the area of the surface portion z = x* + y4 Which is below the plane Z=9|

A drug (D) is produced in a three-stage extraction from the leaves of a tropical plant. About 1000 kg of leaf is required to produce 1 kg of the drug. The extraction solvent (S) is a mixture...

Find the expected NPV , the standard deviation of NPV , and the coefficient of variation of the following project. \ table [ [ State , Probability,NPV ( million ) ] , [ Boom , 3 0 % , 5 0 0 ] , [...

2Al(s)+3H2SO4(aq)Al2(SO4)3(aq)+3H2(g)2Al(s)+3H2SO4(aq)Al2(SO4)3(aq)+3H2(g) Suppose you want to dissolve an aluminum block with a mass of 15.3 gg . What minimum mass of H2SO4H2SO4 (in gg) do you need?

=+ 5. Draw a well-labeled graph that illustrates the steady state of the Solow model with population

=+ c. Assume that the depreciation rate is 10 percent per year. Make a table showing steadystate capital per worker, output per worker, and consumption per worker for saving rates

=+ 4. Devoting a larger share of national output to investment would help restore rapid productivity growth and rising living standards. Do you agree with this claim? Explain, using the Solow model.