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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!