search

zipperer / migrate_database_with_michael

0 stars 0 forks source link

Presentation titles file -- separate SN090901 column into three columns (day, morning_or_night, date) #39

Closed zipperer closed 8 months ago

zipperer commented 8 months ago

Take row with initial columns

1350 | SN090901 | SOLOMON'S TEMPLE A SHADOW (PATTERN) OF THE NEW TESTAMENT TEMPLE, THE CHURCH (WHICH TEMPLE WE ARE)

and make

1350 | SN090901 | Sunday | Night | 2001-09-09 | SOLOMON'S TEMPLE A SHADOW (PATTERN) OF THE NEW TESTAMENT TEMPLE, THE CHURCH (WHICH TEMPLE WE ARE)
zipperer commented 8 months ago

See

  1. pipe_separated_to_columns_for_day_and_date.py
  2. program_number_and_title_pipe_separated_with_columns_for_day_and_date.csv
  3. docker_container_interactions_postgres_add_columns_for_decoded_date.txt

(1) is a python program to read the pipe-separated titles csv file and write a new csv file with additional columns for day, morning or night, and date. (2) is the file (1) made. (3) is interactions for putting (2) into a PostgreSQL table