Question

Write a report over programming. Include numbers on your submission to identify which part of the assignment you are taking care of. 1. (10 points) Include a title that explains in a sentence what you learned or noticed. 2. (70 points) Include your code for the programming assignment Write a code to print to a csv file and read from a csv file 3. (10 points) The output of your code that shows what you have works. 4. (10 points) A conclusion that discusses what you learned or noticed during the assignment.

Answer 1

1. Reading CSV file using Python

The above title was chosen because to read CSV files we can use the library Python has to offer to easily open and read data from CSV files. Python syntax makes the code easier to understand.

2. Python Code:

import csv

with open('file.csv') as csvFileData:
    csvReader = csv.reader(csvFileData, delimiter=',')
    for row in csvReader:
        print(row)

1 import csv with open ('file. csv.) as csVFileData: #"file.csv. is the csv file that needs to be in the same directory/folder as the readCSV.py program csvReader csv.reader (csvFileData, delimiter-',') for row in csvReader: print(row)

3. Output:

['John', 'M', '5ft 3in ', '45 kg']
['Harvey', 'M', '6ft 1in', '167 kg']
['Pauline', 'F', '5ft 9in', '59 kg']
['Ruth', 'F', '5ft 11in', '93 kg']

File Edit View Search Terminal Help daikky@Bubuntu:-$ cd Documents/Chegg/Feb/17/ daikky@Bubuntu:-/Documents/Chegg/Feb/17$ ls file . csv readcsv.ру daikky@Bubuntu : ~/Documents/HomeworkLib/Feb/175 python readcsv.ру 'John', 'M', '5ft 3in', '45 kg' ['Harvey', 'M', '6ft 1in', '167 kg'] ['Pauline', 'F', '5ft 9in', '59 kg'] ['Ruth', 'F', '5ft 11in', '93 kg' daikky@Bubuntu : ~/Documents/Chegg/Feb/175 Ш

4. CSV(Comma-Sepateted Values) files store tabular date in plaintext. Comma (or any other delimiter) is used to separate values in line. Each line stores multiple values for a record.

The import csv is used to import the library files to open csv files in python. The open('file.csv') opens the csv file and the csv.reader(csvFileData, delimiter=',') function reads from it with "," as the delimiter. The file 'file.csv' must reside in the same directory or folder as the readCSV.py python file.

To compile and the program we run the command python readCSV.py from the terminal/command prompt and get out output. It gives an error when the file 'file.csv' is not found in the directory.