How can I integrate data from multiple sources in Jupyter Notebook?

How can I integrate data from multiple sources in Jupyter Notebook?

You can use libraries like Pandas to read data from various sources such as CSV, Excel, SQL databases, and APIs.

Can you show me an example of reading a CSV file?

Sure! You can use the following code:

import pandas as pd

data = pd.read_csv('file_path.csv')
print(data.head())

What if I want to combine data from a SQL database and a CSV file?

You can read both data sources into separate DataFrames and then use pd.merge() to combine them based on a common key.

Can you provide a code snippet for that?

Absolutely! Here's an example:

import pandas as pd
import sqlite3

# Read CSV
csv_data = pd.read_csv('file_path.csv')

# Connect to SQL database
conn = sqlite3.connect('database.db')
sql_data = pd.read_sql_query('SELECT * FROM table_name', conn)

# Merge DataFrames
merged_data = pd.merge(csv_data, sql_data, on='common_key')
print(merged_data.head())