Error while retrieving data from SQL Server using pyodbc python

Question

My table data has 5 columns and 5288 rows. I am trying to read that data into a CSV file adding column names. The code for that looks like this :

cursor = conn.cursor()
cursor.execute('Select * FROM classic.dbo.sample3')

rows = cursor.fetchall()

print ("The data has been fetched")

dataframe = pd.DataFrame(rows, columns =['s_name', 't_tid','b_id', 'name', 'summary'])
dataframe.to_csv('data.csv', index = None)

The data looks like this

s_sname   t_tid   b_id  name   summary
---------------------------------------------------------------------------
db1       001     100   careie  hello this is john speaking blah blah blah

It looks like above but has 5288 such rows.

When I try to execute my code mentioned above it throws an error saying :

ValueError: Shape of passed values is (5288, 1), indices imply (5288, 5)

I do not understand what wrong I am doing.

DeepBlue · Accepted Answer · 2019-07-16 23:01:52Z

1

Use this.

dataframe = pd.read_sql('Select * FROM classic.dbo.sample3',con=conn)
dataframe.to_csv('data.csv', index = None)

answered Jul 16, 2019 at 23:01

DeepBlue

4464 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

Error while retrieving data from SQL Server using pyodbc python

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