Creating a python package to convert /transfer excelsheet data to a mysql Database Table

Last update: Jan 07, 2022

Overview

################################################################Sourcecode:##############################################################

import pandas as pd import sys import mysql.connector as mysql from tkinter import * from tkinter import messagebox

class Convert_ExcelSheet_To_MySqlTable: def init(self,username,password,hostname,excel_file,database_name,number_of_columns,sql): self.excel_file=excel_file self.username=username self.password=password self.hostname=hostname self.sql=sql self.database_name=database_name self.number_of_columns=number_of_columns

   def Convert_to_MySqlDatabaseTable(self):
        root = Tk()
        root.withdraw()
        read=pd.read_excel(self.excel_file, engine='openpyxl')
        read_array=read.to_numpy()
        try:
            con=mysql.connect(user=self.username,password=self.password,host=self.hostname)
            messagebox.showinfo("Authentification", "You have Logged into the database successfully")
            for reading in read_array:
                  finalvalues=[]
                  count=0
                  while count

 #######################Instructions you need to followcarefully##############################
 from excelsheet_to_mysqldatabasetable.excel_converter import Convert_ExcelSheet_To_MySqlTable
 excel_file_path=open(r"C:\Users\LAMECK\Desktop\Excel Converter\documentation\db4.xlsx","rb")
 #Enter your table name and the columns you have in your mysql table .Note the columns in the excel sheet and mysql table should be in the same order. #Enter( %s ) according to the number of columns you have .
 sql=" INSERT INTO db4(serialnumber,entrynumber,volumenumber,district,year,user,hospital) VALUES(%s,%s,%s,%s,%s,%s,%s)"
 convert=Convert_ExcelSheet_To_MySqlTable(username="root",password="tangimeko7583",hostname="localhost",excel_file=excel_file_path,database_name="db4",number_of_columns=7,sql=sql) convert.Convert_to_MySqlDatabaseTable()
 found at ( https://pypi.org/project/excelsheet-to-mysqldatabasetable/2.4.0/ )

Creating a python package to convert /transfer excelsheet data to a mysql Database Table

Related tags

Overview

Owner

Odiwuor Lameck

A selection of SQLite3 databases to practice querying from.

Create a database, insert data and easily select it with Sqlite

Pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).

aioodbc - is a library for accessing a ODBC databases from the asyncio

Class to connect to XAMPP MySQL Database

Makes it easier to write raw SQL in Python.

A database migrations tool for SQLAlchemy.

Anomaly detection on SQL data warehouses and databases

Confluent's Kafka Python Client

DataStax Python Driver for Apache Cassandra

aiomysql is a library for accessing a MySQL database from the asyncio

Creating a python package to convert /transfer excelsheet data to a mysql Database Table

Little wrapper around asyncpg for specific experience.

The JavaScript Database, for Node.js, nw.js, electron and the browser

Implementing basic MySQL CRUD (Create, Read, Update, Delete) queries, using Python.

a small, expressive orm -- supports postgresql, mysql and sqlite

PostgreSQL database adapter for the Python programming language

A Relational Database Management System for a miniature version of Twitter written in MySQL with CLI in python.

Neo4j Bolt driver for Python

SQL for Humans™