Ms access python dataframe

import pyodbc
import pandas as pd
...
cnxn = pyodbc.connect('DRIVER={{Microsoft Access Driver (*.mdb, *.accdb)}};DBQ=' + \
                      '{};Uid={};Pwd={};'.format(db_file, user, password)

query = "SELECT * FROM mytable WHERE INST = '796116'"
dataf = pd.read_sql(query, cnxn)
cnxn.close()

Source: stackoverflow.com

Similar codes

12 votes354 views6 answers
Python flask
Python Flask
0 vote263 views1 answer
How to get a mock image in django?
Python
10 votes268 views4 answers
Multiply each element in list python
Python
0 vote267 views1 answer
Give cell format to condition pandas dataframe
Python
0 vote256 views1 answer
Merge two data frames based on common column values in Pandas
Python
43 votes271 views3 answers
Python system arguments
Python
0 vote257 views1 answer
Pass query params django template
Python
45 votes236 views3 answers
Mischievous in spanish
Python
0 vote266 views1 answer
Train_test_split from sklearn.selection
Python
11 votes253 views3 answers
How to print all elements of a dictionary in python
Python