Question

PYTHON Hello can someone create the following functions? I'm not sure how to start on them.

makeDictionary

Define a function named makeDictionary with two parameters. The first argument passed the function must be a list of strings to be used as keys, while the second is a list of the same length containing values (of some type).

This function must return a dictionary consisting of the keys paired with the corresponding values.

For example, makeDictionary(['apno','value'],['REP-12','450']) must return this dictionary: {'apno': 'REP-12', 'value': '450'}

readDataFromCSVFile

N.B. When opening a file for reading you will need to add an extra keyword parameter to the open(...) function call in order for AutoLab to properly handle all the characters in the CSV files: encoding="utf-8". The function call should be:

open(filename, newline='', encoding="utf-8")

Define a function named readDataFromCSVFile with one parameter. The argument passed to the function should be a string which is the name of a CSV file containing data. The file will have a header row and data rows. For example, suppose the file sample.csv contains:

apno,value

REP-12,450

ELEC-72,2000

The file has a header row:

apno,value

After the header row the file has two data rows:

REP-12,450

ELEC-72,2000

This function must return a list of dictionaries. Each dictionary must pair a key from the header row with the corresponding value from given data row. For example, readDataFromCSVFile("sample.csv") must return the following dictionary: [{'apno': 'REP-12', 'value': '450'},{'apno': 'ELEC-72', 'value': '2000'}]

dictionaryToListOfValues

Define a function named dictionaryToListOfValues with two parameters. The first argument of this function will be a list of keys, while the second is a dictionary. This function must return the values associated with each of the keys in the dictionary, in the same order that the keys are given in the first argument. You may assume that each key in the first argument exists as a key in the dictionary.

For example, if d = {'apno': 'ELEC-72', 'value': '2000'} then

dictionaryToListOfValues(['apno','value'],d)

must return

['ELEC-72', '2000']

while

dictionaryToListOfValues(['value','apno'],d)

must return

['2000','ELEC-72']

writeDataToCSVFile

Define a function named writeDataToCSVFile with four parameters. The first argument is a string, the name of the file which data will be written to. The second argument is a list of dictionaries, like the one readDataFromCSVFile produces. The third is a list of keys. You may assume that each key in the third argument exists as a key in each of the dictionaries in the second argument. The fourth is a Boolean value.

This function must write the values from each dictionary as a record to a CSV file. The order of the values in the record must correspond to the order of the keys in the third argument. If the fourth argument is True a header row is written as the first record of the CSV file, followed by the data rows; otherwise only the data rows are written.

For example, if data = [{'apno': 'REP-12', 'value': '450'}, {'apno': 'ELEC-72', 'value': '2000'}] then the call

writeDataToCSVFile("sample_header.csv",data,['value','apno'],True)

must write to the file named sample_header.csv the following contents:

value,apno

450,REP-12

2000,ELEC-72

while the call

writeDataToCSVFile("sample.csv",data,['apno','value'],False)

must write to the file named sample.csv the following contents:

REP-12,450

ELEC-72,2000

Answer 1

****This requires some effort so please drop a like if you are satisfied with the solution****

I have satisfied all the requirements of the question and I'm providing the screenshots of output obtained and files and code for your reference...

Code:

import csv
import os


def makeDictionary(keys, values):
    dict = {}
    for i in range(0, len(keys)):
        dict[keys[i]] = values[i]
    return dict


keys = ['apno', 'value']
values = ['REP-12', '450']
print("Function 1 ", makeDictionary(keys, values))


def readDataFromCSV(name):
    result = []
    filename = os.path.join("C://Users/THE__INFINITY/Desktop", name)
    reader = csv.DictReader(open(filename, newline='', encoding="utf-8"))
    for raw in reader:
        data = {}
        for key in raw.keys():
            data[key] = raw[key]
        result.append(data)
    return result


print("Function 2 ", readDataFromCSV("sample1.csv"))


def dictionaryToListOfValues(keys, dict):
    values = []
    for key in keys:
        values.append(dict[key])
    return values


keys2 = ['apno', 'value']
dict = {'apno': 'ELEC-72', 'value': '2000'}
print("Function 3 ", dictionaryToListOfValues(keys2, dict))
keys2 = ['value', 'apno']
print("Function 3 ", dictionaryToListOfValues(keys2, dict))


def writeDataToCSVFile(name, dicts, keys, header):
    filename = os.path.join("C://Users/THE__INFINITY/Desktop", name)
    if header:
        with open(filename, 'wt', newline='') as file:
            writer = csv.writer(file, delimiter=',')
            writer.writerow(i for i in keys)
            for j in dicts:
                values = []
                for key in keys:
                    values.append(j[key])
                writer.writerow(values)
    else:
        with open(filename, 'wt', newline='') as file:
            writer = csv.writer(file, delimiter=',')
            for j in dicts:
                values = []
                for key in keys:
                    values.append(j[key])
                writer.writerow(values)


# function 4 to write data to a csv file
writeDataToCSVFile("sample2.csv", readDataFromCSV("sample1.csv"), keys2, True)
writeDataToCSVFile("sample3.csv", readDataFromCSV("sample1.csv"), keys, False)

Sample1.csv (input file used for 2nd function):

Output Screenshots:

Function 4 output is a file one with header and one with no header...

Code Screenshots: