This module reads an excel file (NDR PBS Line List) into a pandas data frame and push the data into a local MySQL database. The aim is to perform analysis seamlessly using collated line list from the ...

I'm coming from a MS SQL Server background, where I would just create a job and import for this, and I'd be all set. I don't know MySQL well at all, so I was hoping someone could point me in the right ...

import pandas as pd import mysql.connector import tkinter as tk from tkinter import filedialog, messagebox import os def browse_files(): files = filedialog.askopenfilenames(filetypes=[("Excel files", ...