Python Forum
SyntaxError: multiple statements found while compiling a single statement
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SyntaxError: multiple statements found while compiling a single statement
#1
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'])
Reply
#2
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).
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Create multiple/single csv file for each sql records mg24 6 1,323 Sep-29-2022, 08:06 AM
Last Post: buran
  Reshaping a single column in to multiple column using Python sahar 7 1,968 Jun-20-2022, 12:35 PM
Last Post: deanhystad
  Multiple Loop Statements in a Variable Dexty 1 1,175 May-23-2022, 08:53 AM
Last Post: bowlofred
  Split single column to multiple columns SriRajesh 1 1,290 Jan-07-2022, 06:43 PM
Last Post: jefsummers
  How do you format Update statement with multiple conditions hammer 4 2,040 Dec-16-2021, 10:49 PM
Last Post: hammer
  Delete multiple comments with a single API call (facebook) Ascalon 0 2,268 Dec-04-2021, 08:33 PM
Last Post: Ascalon
  How can I assign "multiple variables" to a single "value"? Psycpus 2 1,810 Oct-04-2021, 03:29 AM
Last Post: deanhystad
  Ploting single column with multiple category drunkenneo 1 1,946 May-26-2021, 04:51 PM
Last Post: jefsummers
  Compiling (PyInstaller issues) TheHolyPyGrenade 1 1,881 Apr-11-2021, 08:30 PM
Last Post: snippsat
  Inserting multiple rows in a single request. swaroop 2 2,852 Jan-11-2021, 01:34 PM
Last Post: swaroop

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020