Python Script to import CSV data into MySQL Database

import pandas as pd 
import mysql.connector as msql 
from mysql.connector import Error 

HOST = "localhost" 
DATABASE = "Employees" 
USER = "root" 
PATH = "data/employees.csv" 

data = pd.read_csv(PATH) 
data = data.to_dict(orient="records") 

val = [(dept["emp_no"], dept["emp_title_id"],dept["birth_date"], dept["first_name"], dept["last_name"], dept["sex"], dept["hire_date"]) for dept in data] 


try: conn = msql.connect(host= HOST, database=DATABASE, user=USER, password='') 
     if conn.is_connected(): 
         cursor = conn.cursor() 
         sql = "INSERT INTO employees (emp_no,emp_title,                     birth_date,first_name,last_name,gender,hire_date) VALUES (%s, %s, %s, %s, %s, %s, %s)" cursor.executemany(sql, val) 
     conn.commit() print("Completed process") 

 except Error as e: 
     print("Error while connecting to MySQL", e)

Comments

Post a Comment

Popular posts from this blog

Where Does Intelligence Begin?

Humans are proud of a lot of things, from particle accelerators to poetry to Pokemon. All of them were made possible because of something humans value extremely highly:  Intelligence. We think of intelligence as a trait like height or strength,  but when we try to define it, things get fuzzy. In a nutshell, intelligence is a mechanism to solve problems.  Especially the problem of staying alive, which involves finding food and shelter,  fighting sexual competitors, or fleeing from predators.  Intelligence is not a single thing;  it includes the ability to gather knowledge, to learn, be creative, form strategies, or engage in critical thinking.  It manifests itself in a huge variety of behaviors.  From hardwired or instinct-like reactions to different degrees of learning to some sort of awareness.  But not all scientists agree where it begins or what even should count as intelligence.  To make this even more complicated,  intelligence...
Read more

Random is not actually indeterministic, its hard to calculate.

Homeopathic remedy  also called astragalus, you take it for  viral infections but you could  substitute that for anything you might  take for diabetes or insomnia or indeed  it could be a healing crystal or  anything that represents an alternative  therapy of your choice, but you might  have a viral infection you might take  astragalus you might then feel better  and decide therefore it must be an  effective cure. The point is it works for  you what more proof could you need the  trouble is that when these things are  tested properly over thousands of people  they are shown to really have no effect  whatsoever. The trap that people fall  into is to think all the evidence I need  is what I know in my head and I feel in  my heart and what I just know to be true  but that doesn't really evidence for it being  true that's just a statement about  how much you believe it and also how...
Read more

Existence Game

Image
Context: A few months ago, in a function, renowned personality "Elon Musk" said: our existence could be a projection from a super-computer. He said: it is possible to simulate the whole earth from a future computer and everything we have seen, is just a piece of code. Like we have seen, a few decades ago, games used to be just a simple triangle with a dot bouncing ball. But now, it is already indistinguishable from the reality; I'm quoting again, it happened only in 4 decades. As compared to the current rate, even in the worst-case scenario, if we presume the rate of advancement in the technology is 1% per year; by the next 100 years, it would be impossible to differentiate the reality and computer simulation. Furthermore, he said, it is definitely possible because it not necessarily required to render the whole earth at the same time; only the required frame would have been processing and the rest is behind the reality. The wall behind you is not necessarily to be render...
Read more