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

PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

PostgreSQL database adapter for the Python programming language

An extension package of 🤗 Datasets that provides support for executing arbitrary SQL queries on HF datasets

MinIO Client SDK for Python

Amazon S3 Transfer Manager for Python

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

Little wrapper around asyncpg for specific experience.

A pythonic interface to Amazon's DynamoDB

python-bigquery Apache-2python-bigquery (🥈34 · ⭐ 3.5K · 📈) - Google BigQuery API client library. Apache-2

Dlsite-doujin-renamer - Dlsite doujin renamer tool with python

A SQL linter and auto-formatter for Humans

Script em python para carregar os arquivos de cnpj dos dados públicos da Receita Federal em MYSQL.

ClickHouse Python Driver with native interface support

edaSQL is a library to link SQL to Exploratory Data Analysis and further more in the Data Engineering.

Pony Object Relational Mapper

Database connection pooler for Python

Py2neo is a comprehensive toolkit for working with Neo4j from within Python applications or from the command line.

A selection of SQLite3 databases to practice querying from.

SQL for Humans™

Async ODM (Object Document Mapper) for MongoDB based on python type hints