Note the types of objects in the dictionary! It is a reverse operation compared to lab 10.13. 1. Create a function load_dict_from_csv(filename) that will accept the string with the file name and returns the loaded storage. 1.0, Use with to open the file with the required filename. 1.1. Crete a future dictionary. Create csv loader to load all lines 1.2. Loop over loader to get each line from the file. Using knowledge about the structure of the dictionary to parse the line (convert it to required types if needed!) and save it to the dictionary. The first element is a key, the other is the values: second is the name, third is the prct, and the rest is the grades_list. 2. You do not have to have any if name _main__" statement, but you can use it and IDE on your computer to test your == program. Examples of function work: storage_save.txt 101,quiz,12,1,2,3,4 102,final,53,10,10,10,10 103,labs,30,100,100,100,97,100,96,100,98,97,100 res = load_dict_from_csv ("storage_save.txt") res >>> { 101: ["quiz", 12, [1,2,3,4]], 102: ["final", 53, [10, 10, 10, 10]], 103: ["labs", 30, [100,100,100,97,100,96,100,98,97,100]] }
Note the types of objects in the dictionary! It is a reverse operation compared to lab 10.13. 1. Create a function load_dict_from_csv(filename) that will accept the string with the file name and returns the loaded storage. 1.0, Use with to open the file with the required filename. 1.1. Crete a future dictionary. Create csv loader to load all lines 1.2. Loop over loader to get each line from the file. Using knowledge about the structure of the dictionary to parse the line (convert it to required types if needed!) and save it to the dictionary. The first element is a key, the other is the values: second is the name, third is the prct, and the rest is the grades_list. 2. You do not have to have any if name _main__" statement, but you can use it and IDE on your computer to test your == program. Examples of function work: storage_save.txt 101,quiz,12,1,2,3,4 102,final,53,10,10,10,10 103,labs,30,100,100,100,97,100,96,100,98,97,100 res = load_dict_from_csv ("storage_save.txt") res >>> { 101: ["quiz", 12, [1,2,3,4]], 102: ["final", 53, [10, 10, 10, 10]], 103: ["labs", 30, [100,100,100,97,100,96,100,98,97,100]] }
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
In python!
![Learning Objectives
Open a file for reading
Process information in a file to store it in a dictionary
• Practice writing code needed for the final project
Instructions
A dictionary is a great way to store information in the real world and it is time for us to try to load it from the file.
If the file looks like this:
id,name,prct,grades_list
e.g.
101,quiz,17,1,2,3,4
102,final,53,100
103,labs,30,100,100,100,97,100,96,100,98,97,100
The dictionary should look like this:
{id: [name, prct, grades_list]}
e.g.
{
101: ["quiz", 12, [1,2,3,4]],
102: ["final", 53, [10, 10, 10, 10]],
103: ["labs", 30, [100,100,100,97,100,96,100,98,97,100]]
}](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffe70859f-d1ee-4d19-93f5-d3c21b44393e%2F8acc2733-3110-477a-986e-302428164870%2Fdod4ew_processed.png&w=3840&q=75)
Transcribed Image Text:Learning Objectives
Open a file for reading
Process information in a file to store it in a dictionary
• Practice writing code needed for the final project
Instructions
A dictionary is a great way to store information in the real world and it is time for us to try to load it from the file.
If the file looks like this:
id,name,prct,grades_list
e.g.
101,quiz,17,1,2,3,4
102,final,53,100
103,labs,30,100,100,100,97,100,96,100,98,97,100
The dictionary should look like this:
{id: [name, prct, grades_list]}
e.g.
{
101: ["quiz", 12, [1,2,3,4]],
102: ["final", 53, [10, 10, 10, 10]],
103: ["labs", 30, [100,100,100,97,100,96,100,98,97,100]]
}
![Note the types of objects in the dictionary!
It is a reverse operation compared to lab 10.13.
1. Create a function load_dict_from_csv(filename) that will accept the string with the file name and returns the loaded storage.
1.0, Use with to open the file with the required filename.
1.1. Crete a future dictionary. Create csv loader to load all lines
1.2. Loop over loader to get each line from the file. Using knowledge about the structure of the dictionary to parse the line (convert it
to required types if needed!) and save it to the dictionary. The first element is a key, the other is the values: second is the name, third
the prct, and the rest is the grades_list.
2. You do not have to have any if
main
statement, but you can use it and IDE on your computer to test your
name
program.
Examples of function work:
storage save.
txt
101,quiz,12,1,2,3,4
102,final,53,10,10,10, 10
103,labs,30,100,100,100,97,100,96,100,98,97,100
res
load_dict_from_csv("storage_save.txt")
res >>> { 101: ["quiz", 12, [1,2,3,4]],
102: ["final", 53, [10, 10, 10, 10]],
103: ["labs", 30, [100,100,100,97,100,96,100,98,97,100]] }](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ffe70859f-d1ee-4d19-93f5-d3c21b44393e%2F8acc2733-3110-477a-986e-302428164870%2F8mjlst8_processed.png&w=3840&q=75)
Transcribed Image Text:Note the types of objects in the dictionary!
It is a reverse operation compared to lab 10.13.
1. Create a function load_dict_from_csv(filename) that will accept the string with the file name and returns the loaded storage.
1.0, Use with to open the file with the required filename.
1.1. Crete a future dictionary. Create csv loader to load all lines
1.2. Loop over loader to get each line from the file. Using knowledge about the structure of the dictionary to parse the line (convert it
to required types if needed!) and save it to the dictionary. The first element is a key, the other is the values: second is the name, third
the prct, and the rest is the grades_list.
2. You do not have to have any if
main
statement, but you can use it and IDE on your computer to test your
name
program.
Examples of function work:
storage save.
txt
101,quiz,12,1,2,3,4
102,final,53,10,10,10, 10
103,labs,30,100,100,100,97,100,96,100,98,97,100
res
load_dict_from_csv("storage_save.txt")
res >>> { 101: ["quiz", 12, [1,2,3,4]],
102: ["final", 53, [10, 10, 10, 10]],
103: ["labs", 30, [100,100,100,97,100,96,100,98,97,100]] }
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education