vipassanaecon

#import needed package
import pandas as pd

#read file and create dataframe
df = pd.read_csv(r"file_path.csv", encoding= 'unicode_escape')
df.head() #view head of dataframe

#convert timestamp/datetime/etc column... from object (or other) datatype to datetime datatype if needed. 
#longest process in this script if needed, otherwise ignore.
df['timestamp'] = df['timestamp'].apply(pd.Timestamp) 

vipassanaecon

vipassanaecon

vipassanaecon

vipassanaecon

vipassanaecon

-- Update example script 3 (final)
update region_table
set isopen = 'Y'
,   isavailable = 'N'
,   isrestricted = 'Y'
,   user_last_modified = 'user_migration'
,   date_last_modified = sysdate
where state_plan_id      =   (
                              select table_id
                              from state_table st

vipassanaecon

-- Update example script 2
"update region_table
set isopen = 'Y' 
,   isavailable = 'N'
,   isrestricted = 'Y'
,   user_last_modified = 'user_migration'
,   date_last_modified = sysdate
where state_plan_id      =   (
                              select table_id  
                              from state_table st

vipassanaecon

-- Update example script 1
= "update region_table
set isopen = 'Y'  "&"
,   isavailable = 'N'
,   isrestricted = 'Y'
,   user_last_modified = 'user_migration'
,   date_last_modified = sysdate
where state_plan_id      =   (
                              select table_id   "&"
                              from state_table st

vipassanaecon

CREATE TABLE IF NOT EXISTS red_wine
                 (
                  id INTEGER PRIMARY KEY AUTOINCREMENT,
                  fixed_acidity REAL NOT NULL,
                  volatile_acidity REAL NOT NULL,
                  citric_acid REAL NOT NULL,
                  residual_sugar REAL NOT NULL,
                  chlorides REAL NOT NULL,
                  free_sulfur_dioxide INTEGER NOT NULL,
                  total_sulfur_dioxide INTEGER NOT NULL,

vipassanaecon

CREATE TABLE IF NOT EXISTS red_wine
                 (
                  id INTEGER PRIMARY KEY AUTOINCREMENT,
                  fixed_acidity REAL NOT NULL,
                  volatile_acidity REAL NOT NULL,
                  citric_acid REAL NOT NULL,
                  residual_sugar REAL NOT NULL,
                  chlorides REAL NOT NULL,
                  free_sulfur_dioxide INTEGER NOT NULL,
                  total_sulfur_dioxide INTEGER NOT NULL,