Mar-12-2020, 03:39 PM
Please assist as i need help with this urgently for an assignment.
Am trying to create a CSV with a set of data using this code but the shell is displaying "Syntax-error: multiple statements found while compiling a single statement": please help review this code.
Am trying to create a CSV with a set of data using this code but the shell is displaying "Syntax-error: multiple statements found while compiling a single statement": please help review this code.
import csv with open ('Mosescsv.csv', 'w',newline='') as f: fieldnames=['column1', 'column2', 'column3', 'column4', 'column5', 'column6'] thewriter=csv.Dicwriter(f, fieldnames=fieldnames) thewriter.writeheader() thewriter.writerow(['column1':'Opinion', 'column2':'Facts', 'column3':'Experience','column4': 'Positive','column5': 'Negative','column6': 'Neutral']) Please assist as this is urgent. thewriter.writerow(['column1':'Positive', 'column2':'Optimistic','column3': 'Critical', 'column4':'2','column5': '0', 'column6':'1']) thewriter.writerow(['column1':'Neutral', 'column2':'Neutral', 'column3':'Critical','column4': '0','column5': '1','column6':'2']) thewriter.writerow(['column1':'Positive', 'column2':'Neutral', 'column3':'Good','column4':'2', 'column5': '0','column6':'1']) thewriter.writerow(['column1':'Neutral', 'column2':'Neutral', 'column3':'Mild', 'column4':'0', 'column5':'0','column6':'3']) thewriter.writerow(['column1':'Positive', 'column2':'Optimistic', 'column3':'Mild', 'column4':'2', 'column5':'0','column6':'1']) thewriter.writerow(['column1':'Neutral','column2': 'Pessimistic','column3': 'Critical','column4': '0', 'column5':'2','column6':'1']) thewriter.writerow(['column1':'Negative', 'column2':'Pessimistic','column3': 'Critical', 'column4':'0', 'column5': '2','column6':'1']) thewriter.writerow(['column1':'Positive', 'column2':'Optimistic', 'column3':'Good', 'column4':'3','column5':'0','column6':'0']) thewriter.writerow(['column1':'Negative', 'column2':'Optimistic','column3': 'Mild','column4': '1', 'column5':'1','column6':'1']) thewriter.writerow(['column1':'Negative', 'column2':'Pessimistic', 'column3':'Critical','column4': '0', 'column5':'3','column6':'0']) thewriter.writerow(['column1':'Negative','column2': 'Optimistic', 'column3':'Critical','column4': '1','column5': '2','column6':'0']) for i in range (1,3): thewriter.writerow(['column1':'Positive', 'column2':'Pessimistic','column3': 'Mild', 'column4': '1', 'column5':'1','column6':'1']) for i in range (1,2): thewriter.writerow(['column1':'Positive','column2': 'Pessimistic','column3': 'Critical','column4': '1', 'column5':'2','column6':'0']) for i in range (1,2): thewriter.writerow(['column1':'Neutral', 'column2':'Neutral','column3': 'Good', 'column4': '1','column5': '0','column6':'2']) for i in range (1,2): thewriter.writerow(['column1':'Negative', 'column2':'Optimistic','column3': 'Good', 'column4':'2', 'column5': '1','column6':'0']) for i in range (1,3): thewriter.writerow(['column1':'Negative', 'column2':'Pessimistic','column3': 'Mild', 'column4':'0', 'column5':'2','column6':'1']) for i in range (1,2): thewriter.writerow(['column1':'Neutral', 'column2':'Optimistic', 'column3':'Critical', 'column4':'1', 'column5':'1','column6':'1']) for i in range (1,2): thewriter.writerow(['column1':'Negative', 'column2':'Neutral','column3': 'Good', 'column4':'1','column5': '1','column6':'1']) for i in range (1,2): thewriter.writerow(['column1':'Negative', 'column2':'Neutral','column3': 'Critical','column4': '0','column5': '2','column6':'1'])