(hcd_env) bkhanhvu@yen2:~/idhlab/bkhanhvu/hcd_esg$ python3 scripts/create_jpv1_6_011825_agg.py --output  /home/users/bkhanhvu/idhlab/hcd_esg/data/final/jpv1_6_112425_agg.csv
2025-11-24 17:28:50 | INFO     | Reading sentiment reviews from /zfs/projects/faculty/jungho-idhlab/Hannah/_job_posting/04_EEOC/data/raw/sentiment_individual_reviews.csv
2025-11-24 17:32:13 | INFO     | Adding month-year keys to the sentiment panels
2025-11-24 17:33:44 | INFO     | Aggregating Version 1 sentiment metrics by rcid and month-year
2025-11-24 17:33:46 | INFO     | Loading job posting main table from /zfs/projects/faculty/jungho-idhlab/Hannah/_job_posting/04_EEOC/data/raw/12_job_posting_main_with_score_and_reasons.pkl
2025-11-24 17:36:05 | INFO     | Loading rcid reference table from /zfs/projects/faculty/jungho-idhlab/Hannah/_job_posting/04_EEOC/data/raw/df_reference_simple_clean.dta
2025-11-24 17:36:09 | INFO     | Loading cik reference table from /zfs/projects/faculty/jungho-idhlab/Hannah/_job_posting/04_EEOC/data/raw/jp_main_temp2_merged.dta
2025-11-24 17:38:47 | INFO     | Preparing job postings for sentiment merge
2025-11-24 17:39:08 | INFO     | Merging job postings with sentiment (JPV1)
2025-11-24 17:39:11 | INFO     | Selecting and renaming columns prior to aggregation
2025-11-24 17:39:12 | INFO     | Aggregating to firm-month level
2025-11-24 17:39:12 | INFO     | Writing aggregated dataset to /home/users/bkhanhvu/idhlab/hcd_esg/data/final/jpv1_6_112425_agg_dan.csv
2025-11-24 17:39:12 | INFO     | Done. Rows written: 5169