Using pyodbc&pandas to load a Table data to df

Thread Rating:

Thread Modes

Using pyodbc&pandas to load a Table data to df

tester_V
Minister of Silly Walks

Posts: 414

Threads: 111

Joined: Apr 2020

Reputation: 6

Sep-09-2023, 08:55 PM

I found out how to get data from a table.

sql_query = 'SELECT * FROM ToolHistory'
df = pd.read_sql(sql_query, conn)
print(df)

thank you.

Find

Messages In This Thread

RE: Using pyodbc&pandas to load a Table data to df - by tester_V - Sep-09-2023, 08:55 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Converting Pandas DataFrame to a table of hourly blocks	Abedin	1	522	Apr-24-2025, 01:05 PM Last Post: snippsat
	Load data in Oracle	muzokh	0	1,223	Mar-08-2024, 11:19 PM Last Post: muzokh
	Better python library to create ER Diagram by using pandas data frames as tables	klllmmm	0	3,160	Oct-19-2023, 01:01 PM Last Post: klllmmm
	Trying to get counts/sum/percentages from pandas similar to pivot table	cubangt	6	3,392	Oct-06-2023, 04:32 PM Last Post: cubangt
	python pandas sql table with header	mg24	3	4,382	Dec-08-2022, 08:31 PM Last Post: Larz60+
	Load multiple Jason data in one Data Frame	vijays3	6	2,777	Aug-12-2022, 05:17 PM Last Post: vijays3
	panda table data	kucingkembar	0	1,678	Mar-01-2022, 10:38 PM Last Post: kucingkembar
	Sorting table data	Blacktime2	1	1,878	Feb-26-2022, 07:05 PM Last Post: ibreeden
	pyodbc	gmerritt	8	5,059	Feb-21-2022, 07:21 PM Last Post: gmerritt
	Move a particular row in pandas data frame to last row	klllmmm	0	5,755	Dec-27-2021, 09:11 AM Last Post: klllmmm

Users browsing this thread: 1 Guest(s)