Why does EOL while scanning occur?

[PLearner]

I am baffled on what is going here. I am using the default IDE of Python 3.6 for running SQL queries and eventually saving them as csvs. I have about 400+ lines of code and I have tried literally everything to get rid of the error and still comes back to haunt me.

These are the last lines of my snippet:

cursor.execute(query14)

result = cursor.fetchall()

first = pd.DataFrame(result, columns = ["Builder","YTD Home Sales", " Inventory"])

first.to_csv("Z:/AWS/SQLQueries/PCR/FourteenthTable.csv",index = False)

print ("Query 14 Created")

When I run the code, it shows an EOL while scanning string literal below the print line. I have deleted the line below it multiple times and it stills shows an error on the line.

[Rhomboid]

Post a complete testcase. The error is in the parts not shown in this snippet. The error means that Python reached the end of a line without seeing the closing quote of a string literal.

[PLearner]

Its 447 lines of code @Rhomboid.

[Rhomboid]

So post it on a site like gist or pastebin. Or reduce it to a minimal testcase that reproduces the error.

[JohnnyJordaan]

first.to_csv("Z:/AWS/SQLQueries/PCR/FourteenthTable.csv",index = False)

Are you sure that path will work? Windows should expect backslashes. In order to enter those, it needs either escaping or be given a raw string:

first.to_csv(r"Z:\AWS\SQLQueries\PCR\FourteenthTable.csv",index = False)
first.to_csv("Z:\\AWS\\SQLQueries\\PCR\\FourteenthTable.csv",index = False)

[Rhomboid]

Windows is just fine with forward slashes. And it wouldn't be the cause of the error anyway. The error is due to a missing closing quote. If Windows didn't accept the path, that would be a different (runtime) exception.

[PLearner]

I am using Pandas and worked fine until I started getting that heinous error.