Breaking News: Grepper is joining You.com. Read the official announcement!

dataframe to sql

Add Answer

Innocent Iguana answered on May 16, 2021 Popularity 10/10 Helpfulness 5/10

answer dataframe to sql

related SQL to DataFrame

related pandas to sql how to use

dataframe to sql

Comment

import csv, sqlite3

# Create a database
con = sqlite3.connect("my_db.db")
cur = con.cursor()

# For inline sql query in jupyter
%load_ext sql

# Connect to database
%sql sqlite:///my_db.db

import pandas as pd
df = pd.read_csv("file_name.csv")
df.to_sql("table_name", con, if_exists='replace', index=False,method="multi")

# Run your query
%%sql
SELECT * FROM table_name LIMIT 3

Popularity 10/10 Helpfulness 5/10 Language python

Source: Grepper

Tags: dataframe sql

Link to this answer
Share Copy Link

Contributed on Feb 16 2023

Innocent Iguana

0 Answers Avg Quality 2/10

Closely Related Answers

SQL to DataFrame

Comment

import pandas as pd
import pyodbc 
conn = pyodbc.connect('Driver={SQL Server};'
                      'Server=RON\SQLEXPRESS;'
                      'Database=TestDB;'
                      'Trusted_Connection=yes;')

cursor = conn.cursor()

sql_query = pd.read_sql_query('SELECT * FROM TestDB.dbo.Person',conn)
print(sql_query)
print(type(sql_query))

Popularity 10/10 Helpfulness 5/10 Language sql

Source: datatofish.com

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on May 16 2021

Smiling Stag

0 Answers Avg Quality 2/10

pandas to sql how to use

Comment

-2

pandas to_sql 的method参数作用

Popularity 9/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: pandas-to-sql pa

Link to this answer
Share Copy Link

Contributed on Mar 27 2023

Chen Liang

0 Answers Avg Quality 2/10

dataframe to sql

Contents

More Related Answers

dataframe to sql

Closely Related Answers

SQL to DataFrame

pandas to sql how to use

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.