GemKW

#TITANIC DATASET

import pandas as pd
file_path = r"C:\Users\gemyk\Downloads\titanic.csv"

titanic = pd.read_csv(file_path)
titanic.head()

titanic.tail(10)

GemKW

-- PART A: DATABASE DESIGN --

-- CREATE DATABASE ecommerce_db1;
USE ecommerce_db1;

/*
CREATE TABLE geolocation (
geolocation_id INT PRIMARY KEY,
geolocation_zip_code_prefix VARCHAR(10),
geolocation_lat DECIMAL(10,8),