Skip to content

README.md

Latest commit

 

History

History
17 lines (8 loc) · 785 Bytes

README.md

File metadata and controls

17 lines (8 loc) · 785 Bytes

ReadSQL

A tutorial on how to access a SQL database using Python or R.

Read a SQL database using Python

readSQL.ipynb: a Jupyter Notebook that shows how to access the iris dataset in SQLite format by either using pandas library (to import the data into a dataframe) or using SQL commands by calling cursor.execute() in sqlite library.

First, download the iris dataset from Kaggle: https://www.kaggle.com/uciml/iris/data

You need to have installed these Python libraries: sqlite, pandas

Read a SQL database using R

readSQL.R: an introductory R script on how to access a SQL database and send basic queries in R using RSQLite library