Skip to content

Latest commit

 

History

History
14 lines (12 loc) · 908 Bytes

README.md

File metadata and controls

14 lines (12 loc) · 908 Bytes
Raw

Reviews

steps for ETL process:

    1. \copy characteristics FROM '/Users/jacobward/Downloads/characteristics.csv' DELIMITER ',' CSV HEADER;
    1. \copy characteristic_reviews FROM '/Users/jacobward/Downloads/characteristic_reviews.csv' DELIMITER ',' CSV HEADER;
    1. \copy reviews FROM '/Users/jacobward/Downloads/reviews.csv' DELIMITER ',' CSV HEADER;
    1. \copy photos FROM '/Users/jacobward/Downloads/reviews_photos.csv' DELIMITER ',' CSV HEADER;

then alter the table for reviews to have strings to later be converted into numbers

    1. alter table reviews alter column recommend type varchar(8);
    1. UPDATE reviews set recommend = '0' where recommend = 'false';
    1. UPDATE reviews set recommend = '1' where recommend = 'true';

next change the data to numbers instead of strings

    1. ALTER TABLE reviews ALTER COLUMN recommend TYPE SMALLINT USING recommend::integer;