Project Description

Developed two Python functions, sql_to_csv and csv_to_sql, enabling bidirectional data conversion.

Key Features

• Utilized SQLite3 library for SQL database connections and CSV module for handling CSV data.
• Implemented robust SQL queries for SELECT and CREATE operations to ensure accurate data retrieval and table creation.
• Leveraged pandas library for efficient data manipulation during SQL to CSV conversion.
• Ensured tool versatility by enabling users to translate data for specific tables within the database.
• Employed StringIO for streamlining CSV content processing and insertion into the SQLite database.

Usage

1. Run sql_to_csv to convert data from SQL to CSV.
2. Run csv_to_sql to convert data from CSV to SQL.

Dependencies

• SQLite3
• CSV module
• pandas