Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question

Python

[画像:LAB ASSIGNMENTS, CONT. • Write a program called data_collection.py to accept input from the user and create a .csv file that holds the name, email, and phone COMMAND MENU view - View contact file add - Add contact to the file exit - Exit program number for each contact. Command: view Name Email Phone The add function collects data for one person Command: add at a time in this format: name,email,phone. Enter a contact in this format: name,email,phone: Mickey Mouse,mmouse@gmail.com,123-456-7890 Command: add Then it writes the data to a .csv file Enter a contact in this format: name, email, phone: Donald Duck,dduck@gmail.com,456-789-0123 Command: add 08 Enter a contact in this format: name,email,phone: Road Runner,rrunner@gmail.com,789-012-3456 The view function reads from the .csv file Command: view Name Email Phone and displays the data in columns, with appropriate headings. Mickey Mouse Donald Duck Road Runner mmouse@gmail.com dduck@gmail.com 123-456-7890 456-789-0123 rrunner@gmail.com 789-012-3456 don't have to include your .csv file, since it can be re-created when running. NOTE: you The program creates a .csv file. The add function allows you to add to it, and the view function reads from it – in columns 3 190 200 ]
expand button
Transcribed Image Text:LAB ASSIGNMENTS, CONT. • Write a program called data_collection.py to accept input from the user and create a .csv file that holds the name, email, and phone COMMAND MENU view - View contact file add - Add contact to the file exit - Exit program number for each contact. Command: view Name Email Phone The add function collects data for one person Command: add at a time in this format: name,email,phone. Enter a contact in this format: name,email,phone: Mickey Mouse,mmouse@gmail.com,123-456-7890 Command: add Then it writes the data to a .csv file Enter a contact in this format: name, email, phone: Donald Duck,dduck@gmail.com,456-789-0123 Command: add 08 Enter a contact in this format: name,email,phone: Road Runner,rrunner@gmail.com,789-012-3456 The view function reads from the .csv file Command: view Name Email Phone and displays the data in columns, with appropriate headings. Mickey Mouse Donald Duck Road Runner mmouse@gmail.com dduck@gmail.com 123-456-7890 456-789-0123 rrunner@gmail.com 789-012-3456 don't have to include your .csv file, since it can be re-created when running. NOTE: you The program creates a .csv file. The add function allows you to add to it, and the view function reads from it – in columns 3 190 200
Expert Solution
Check Mark
Still need help?
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Create your own original .csv file named lab16.csv, with at
least 3 columns and 6 rows of data. You can use PyCharm, Excel,
Notepad or another program to create a .csv file. But make sure
to put the .csv file in your project folder.

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Create your own original .csv file named lab16.csv, with at
least 3 columns and 6 rows of data. You can use PyCharm, Excel,
Notepad or another program to create a .csv file. But make sure
to put the .csv file in your project folder.

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Knowledge Booster
Background pattern image
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
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education