edaSQL is a library to link SQL to Exploratory Data Analysis and further more in the Data Engineering. This will solve many limitations in the SQL studios available in the market. Use the SQL Query language to get your Table Results.
Install dependency Packages before installing edaSQL
pip install pyodbc
pip install ipythonOptional dependency for better visualization - Jupyter Notebook
pip install notebookNow Install using pip . Offical Python Package Here!!
pip install edaSQL(OR)
Clone this Repository. Run this from the root directory to install
python setup.py install
Read the detailed documentation in readthedocs.io (still under the development)
The license for edaSQL is MIT license
Stuck on your edaSQL code or problem? Any other questions? Don't hestitate to send me an email (selva221724@gmail.com).
Access the sample Jupyter Notebook here!!
Access the Sample Data Used in this Repo
- CSV
- DataBase Backup ( you can restore the DB in SQL Studio )
edaSQL for DataFrame: If you are using the CSV or Excel as a source , Read using the Pandas & start from the 3. Data Overview
import edaSQL
import pandas as pdedasql = edaSQL.SQL()
edasql.connectToDataBase(server='your server name',
database='your database',
user='username',
password='password',
sqlDriver='ODBC Driver 17 for SQL Server')sampleQuery = "select * from INX"
data = pd.read_sql(sampleQuery, edasql.dbConnection)insights = edaSQL.EDA(dataFrame=data,HTMLDisplay=True)
dataInsights =insights.dataInsights()deepInsights = insights.deepInsights()eda = edaSQL.EDA(dataFrame=data)
eda.pearsonCorrelation()eda.spearmanCorrelation()eda.kendallCorrelation()eda.missingValuesPlot(plot ='matrix')eda.missingValuesPlot(plot ='bar')eda.missingValuesPlot(plot ='heatmap')eda.missingValuesPlot(plot ='dendrogram')eda.outliersVisualization(plot = 'box')eda.outliersVisualization(plot = 'scatter')outliers = eda.getOutliers()