Skip to content

pirmoradian/ReadSQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

Read a SQL database like iris using python or R

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published