Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How Do I Use A Database Research Tools You Can Use

Authors: Laura La Bella

1st Edition

1622753763, 978-1622753765

More Books

Students also viewed these Databases questions

Question

Proficiency with Microsoft Word, Excel, PowerPoint

Answered: 1 week ago