Question
Read the following data set: https://archive.ics.uci.edu/ml/machine-learning-databases/adult/adult.data Task: 1. Create an sqlalchemy engine using a sample from the data set 2. Write two basic update queries
Read the following data set: https://archive.ics.uci.edu/ml/machine-learning-databases/adult/adult.data Task: 1. Create an sqlalchemy engine using a sample from the data set 2. Write two basic update queries 3. Write two delete queries 4. Write two filter queries 5. Write two function queries
starts like this:
import sqlalchemy import pandas as pd from sqlalchemy import create_engine
df = pd.read_csv('https://archive.ics.uci.edu/ml/machine-learning-databases/adult/adult.data',sep=",",header=None) df.columns=['age','workclass','fnlwgt','education','educationNum','marital-status','occupation','relationship','race','sex','capital-gain','capital-loss','hours-per-week','native-country','income'] engine = create_engine('sqlite:///myData.db') df.to_sql('alchemynew', engine)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started