Python Forum

Full Version: SyntaxError: multiple statements found while compiling a single statement
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.
 
 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'])
Look at line 9. You have a list where the inside looks like a dictionary, it's clearly a syntax issue.

Also, please make sure to post proper code next time - look at line 11, and the random indentation on line 18 (and others).