Here in this case it created with file name output.sqlite Now we have.sqlite how can we run SQL queries on that using Python We can do it using another package named sqlite3.

After import of this package we need to make a connection with database on which we need to perform SQL queries.

That means here we convert yourcsvfile.csv - output.sqlite.

So the database table name in sqlite is yourcsvfile.

Source code: import sqlite3 consqlite3.connect(output.sqlite) filterdatapd.readsqlquery(SELECT FROM yourcsvfile,con) Here your filtereddata is Data Frame.

Get this newsletter By signing up, you will create a Medium account if you dont already have one.

Review our Privacy Policy for more information about our privacy practices.

Check your inbox Medium sent you an email at to complete your subscription.

Follow Analytics Vidhya Follow Analytics Vidhya is a community of Analytics and Data Science professionals.

We are building the next-gen data science ecosystem Follow Written by result of strain Follow I am a ML enthusiast.

Analytics Vidhya Follow Analytics Vidhya is a community of Analytics and Data Science professionals.

We are building the next-gen data science ecosystem More From Medium Public WordPress and Private Database on AWS EC2 Daksh Jain Interacting with Classes Lee McCormick The starters guide to service workers Yannik Schmidt in Anti Clickbait Coalition How to Debug Queries by Just Using Spark UI Cinto in The Startup Creational Design Pattern: Builder Petey in The Startup Building your own MTurk-style app in R using ShinyFlexdashboard Eric Green in Nivi Convert DotNet Core Web App to AWS Lambda App in 5 Minutes Jazz Tong in The Startup The Magic of Associations with ActiveRecord Casey van roose Learn more.

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking.

Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface.

Follow the writers, publications, and topics that matter to you, and youll see them on your homepage and in your inbox.

If you have a story to tell, knowledge to share, or a perspective to offer welcome home.

Csv To Sqlite3 Python