[x] Inner join credit_ratings_on_earnings_call_dates.csv (on columns ticker, earnings_call_date) with calls.csv (on columns company, date)
[x] Inner join this with the three tabuler_fin_data files (on columns company, year, quarter from earnings calls and columns symbol, calendarYear, period (with Q removed) from fin data)
[x] Save as all_data.csv. Also save in Apache Arrow parquet/a columnar data format so we can read in the columns without the calls for some simple summary stats later like how counting number of companies. If that doesn't work then save a csv copy without the transcript/call text column.
We are ready for this.
all_data.csv
. Also save in Apache Arrow parquet/a columnar data format so we can read in the columns without the calls for some simple summary stats later like how counting number of companies. If that doesn't work then save a csv copy without the transcript/call text column.all_data_sample.csv