Error in reading an sql file using pandas

Question

I have an sql file locally stored in my PC. I want to open and read it using the pandas library. Here it iswhat I have tried:

 import pandas as pd
 import sqlite3

 my_file = 'C:\Users\me\Downloads\\database.sql'
 #I am creating an empty database
 conn = sqlite3.connect(r'C:\Users\test\Downloads\test.db')
 #I am reading my file 
 df = pd.read_sql(my_file, conn)

However, I am receiving the following error:

DatabaseError: Execution failed on sql 'C:\Users\me\Downloads\database.sql': near "C": syntax error

try my_file = r'C:\Users\me\Downloads\\database.sql' so you pass a raw string, or use forward slashes — EdChum
– EdChum, Commented Mar 8, 2017 at 13:15
remove the double \\ and change to a single \ in the .sql path, with the raw string encoding as what EdChum said earlier — Scratch'N'Purr
– Scratch'N'Purr, Commented Mar 8, 2017 at 13:18
To elaborate on @EdChum's comment, Python will try to convert everything after '\U' in 'C:\Users' to unicode which will break the "path string". Definitely use r to signify it's a raw string. Also see: en.wikipedia.org/wiki/… — DeepSpace
– DeepSpace, Commented Mar 8, 2017 at 13:19

shreyashSpark · Accepted Answer · 2017-06-28 10:19:35Z

1

Try moving the file to D:// Sometimes Python is not granted access to read/write in C. Hence may be that is an issue.

You can also try alternative method using cursors.

cur=conn.cursor()

r=cur.fetchall()

This r would contain a tuple of your dataset.

edited Jun 28, 2017 at 10:19

answered Jun 28, 2017 at 9:58

shreyashSpark

112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in reading an sql file using pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related