Python

Search

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()

Comment

PREVIOUS	NEXT

Code Example
Python :: drawing arrows in tkinter
Python :: print elements without print function in python
Python :: python requests get
Python :: print pretty in python
Python :: progressbar time in python
Python :: dimension of tensor
Python :: randint python
Python :: odd or even in python
Python :: selenium firefox webdriver
Python :: french to english
Python :: cannot convert float NaN to integer
Python :: import argv python
Python :: change dictionary value python
Python :: pandas select rows by multiple conditions
Python :: check anonim user django
Python :: print list in python
Python :: python code for where to save the figures
Python :: feature importance naive bayes python
Python :: Example of lambda function in python with list
Python :: python dataframe replace nan with 0
Python :: python program to find largest number in a list
Python :: python numpy array size of n
Python :: pyqt menubar example
Python :: python nonlocal
Python :: pandas categorical to numeric
Python :: lerp function
Python :: python dictionary add key-value pair
Python :: python array get index
Python :: dataframe string find count
Python :: sort an array python

Search

PYTHON

ms access python dataframe

ADD CONTENT