Disk I/O Error when importing from SQL into python

Question

import sqlite3
import pandas as pd
slice3_path=r"F:\GM RWA\Database\Wild.sql"

conn = sqlite3.connect(slice3_path)

sql='''SELECT DOG, CAT, TIGER
FROM
(SELECT *
FROM "Mammals")
GROUP BY DOG, CAT, TIGER
ORDER BY TIGER asc'''
df = pd.read_sql(sql=sql, con=conn)

print(df)

This is the code I have written to try to import an existing query I've written in DB Browser for SQ Lite into python. However, I received an error message that says, sqlite3.OperationalError: disk I/0 Error and claiming there was a pandas.io.sql.Databased Error, and the Execution failed on sql. Any idea why this is happening?

spejsy · Accepted Answer · 2018-07-02 13:22:43Z

0

You need to surround your string with quotes:

slice3_path = r"F:\GM RWA\Database\Wild.sql"

The r in front of the string tells Python to treat the backslashes as just backslashes.

answered Jul 2, 2018 at 13:22

spejsy

1238 bronze badges

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

1 Comment

throway172 Over a year ago

Gotcha thanks, that fixed a lot of it, I edited my question because there's another weird error, but thank you that was helpful!

Collectives™ on Stack Overflow

Disk I/O Error when importing from SQL into python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related