
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Computer Science
Python!
Compose a program that reads in a csv file filters and splits the data. For example given example.csv PYTHON please!
lebron james 55
michael jordan 35
allen iverson 89
ouput creates 2 new files one with
lebron
michael
allen
and the second one with leaving the numbers out due to the filter
james
jordan
iverson
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 nowThis is a popular solution!
Step by stepSolved in 4 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.Similar questions
- There are six strings of length 4 which cannot be produced by the following regular expression over the alphabet Σ = {a, b}. What are they? (a+bb)*(ab+ba) (aa + b)* Please select file(s) Select file(s)arrow_forwardPYTHON I have a file name KindOfNumbers.csv In that csv file there are these numbers: 2, 3, 6, 8, 9, 13, 16, 15, 28, 97, 64, 67, 59, 100, 128, 496, 386 893 4567, 843, 894, 935, 974, 863, 991. In PYTHON, After reading the data from the csv file, CREATE THE FOLLOWING LISTS FROM GIVEN NUMBERS: _PRIME NUMBERS _PERFECT NUMBERS _ODD NUMBERS _EVEN NUMBERS ***EACH LIST SHOULD BE SORTED. ***WRITE THE ARRAYS, INCLUDING THE SORTED ORIGINAL, TO A FILE WITH APPROPRIATE DESCRIPTION INCLUDING THE NUMBERS OF VALUES IN THE ARRAY.arrow_forwardwrite java programarrow_forward
- in python Write a program that will open a file .csv, read its contents and print them out. Your output should look like this: .csv (look the image) the file looks like these image First Last Age Wagejane Smith 21.00 21.50Jack Jones 20.00 19.50Edgar Martinez 22.00 22.75Zanab Sayegh 21.00 21.75arrow_forwardIN PYTHON: Decrypting with ascii I have a file called 'dict.txt'. This file contains over 50,000 english words. One word from this file is used as a key (we do not know which one of course). Some have capital letters. I have another file called 'decrypt.txt' which is a file containing a string of numbers i must decrypt using a key found in the 'dict.txt'. This 'decrypt.txt' file message has length of 300. My question is, since i do not know which word (from the file with the 50,000+ words) is the key I must use to decrypt the other file, how do I write a function that: loops through all possible keys from 'dict.txt' to find the one that decrypts my file 'decrypt.txt' best? Somehow i must count how many 'words' are actual words to determine which key is best and then print my final decrypted message.arrow_forwardJava Your program must read a file called personin.txt. Each line of the file will be a person's name, the time they arrived at the professor's office, and the amount of time they want to meet with the professor. These entries will be sorted by the time the person arrived. Your program must then print out a schedule for the day, printing each person's arrival, and printing when each person goes in to meet with the professor. You need to print the events in order of the time they happen. In other words, your output will be sorted by the arrival times and the times the person goes into the professor's office. In your output you need to print out a schedule. In the schedule, new students go to the end of the line. Whenever the professor is free, the professor will either meet with the first person in line, or meet with the first person in line if nobody is waiting. Assume no two people arrive at the same time. You should solve this problem using a stack and a queue. You can only…arrow_forward
- python: Write a program that will open the file dataFile.csv Download dataFile.csv, read its contents and print them out. Your output should look like this: First Last Age Wagejane Smith 21.00 21.50Jack Jones 20.00 19.50Edgar Martinez 22.00 22.75Zanab Sayegh 21.00 21.75arrow_forwardPython Soulution to 1arrow_forwardUsing Python Spark Read each text files that are provided and convert each words in the file to lower case. (I cannot upload the text files so if you find a folder online with 15 text documents that would work) Create a list with words from each text files. Remove stop words from each list and get the final list of words for each text files. (The list of stop words are provided in stopwords.txt)arrow_forward
- Assume that you are designing a simple text editor (like Notepad) that supports inserting text, copy, paste and editing for any size file (including book-length files). Between the String objects and StringBuffer objects, which one is more appropriate and why? O String, because StringBuffer is read-only String, because it will execute more efficiently String, because only simple operations are needed StringBuffer, because it allows for changing the characters stored in the object StringBuffer, because it has copy and paste methodsarrow_forwardThis is phython not Java Lab: Write a file copying program. The program asks for the name of the file to copy from (source file) and the name of the file to copy to (destination file). The program opens the source file for reading and the destination file for writing. As the program reads each line from the source file and it writes the line to the destination file. When every line from the source file has been written to the destination file, it close both files and print “Copy is successful.” In the sample run, “add.py” is the source file and “add-copy.py” is the destination file. Note that both “add-copy.py” is identical to “add.py” because “add-copy.py” is a copy of “add.py”. Sample run: Enter file to copy from: add.py Enter file to copy to : add-copy.py Copy is successful. Source file: add.py print("This program adds two numbers") a = int(input("Enter first number: ")) b = int(input("Enter second number: ")) print(f"{a} + {b} = {a+b}") Destination…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

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