Skip to content

This GitHub repository contains a Python script for automated conversion of CSV data into an SQLite database with automatic data type detection.

License

Notifications You must be signed in to change notification settings

plusben/CSVtoSQLite3

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

CSVtoSQLite3

This GitHub repository contains a Python script for automated conversion of CSV data into an SQLite database with automatic data type detection.

Features:

  • Converts CSV data into an SQLite database.
  • Automatically detects the appropriate data types for each column.
  • Supports both creating a new SQLite database and adding data to an existing one.
  • Easily adaptable to various CSV data structures.

Usage:

  1. Clone this repository to your local machine.

  2. Modify the csv_file_path and sqlite_db_path variables in the script to specify the paths to your CSV file and the desired SQLite database.

  3. Run the script using Python 3.9 or higher.

python csv_to_sqlite.py

  1. The script will create or update the SQLite database with the CSV data.

License:

This project is licensed under the MIT License. See the LICENSE file for details.

Contributors:

Feel free to contribute to this project by creating issues or pull requests.

About

This GitHub repository contains a Python script for automated conversion of CSV data into an SQLite database with automatic data type detection.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages