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'])
