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

jupyter sql

Innocent Iguana answered on January 28, 2023 Popularity 8/10 Helpfulness 5/10

answer jupyter sql

jupyter sql

Comment

# Method 1 = use %%sql Magic command (applies to the entire cell)
%%sql
SELECT * FROM table_name

# Method 2 = use API of a database (postgresql example below)
import psycopg2
import pandas as pd
# Establish connection
conn = psycopg2.connect(database="db_name",
                        host="db_host",
                        user="db_user",
                        password="db_pass",
                        port="db_port")
# Initialize cursor pointer to point at connection object
# Cursor is a control structure that enables traversal over records in database.
cursor = conn.cursor()
# Execute query using the cursor object
query = cursor.execute("SELECT * FROM DB_table")
# Store the result : The result is stored as list of tuples
result = query.fetchall()
# Convert result into tabular format
df = pd.DataFrame(result)
# Close connection
conn.close()

Popularity 8/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: jupyter sql

Link to this answer
Share Copy Link

Contributed on Jan 28 2023

Innocent Iguana

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

jupyter sql

Contents

More Related Answers

jupyter sql

Grepper

Documentation

Social

Legal

Contact

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