Notebook

Jul 17, 2024, 4:07 PM

monthly_ml.xlsx

Missing file

make Date a datime index and resample to quarterly data

The data from the provided Excel file has been successfully loaded and converted. The 'Date' column has been set as the datetime index, and the data has been resampled to a quarterly frequency. The resulting DataFrame shows the mean values for each quarter.
Here is a preview of the first few rows of the quarterly resampled data:
            tsx_sales_estimate  tsx_eps_estimate  cad_ig_sprds  us_ig_sprds  us_hy_sprds  cad_ig_er_index        vix  eco_surprises          tsx
Date
2005-12-31         8605.669700        924.145600      0.613091     0.966886     3.417578       104.565000  12.065000       0.297000  11048.199700
2006-03-31         9465.494467       1113.065333      0.592794     0.860316     3.143145       104.563333  12.226667       0.714667  11914.863267
2006-06-30         9004.094100       1085.737833      0.597217     0.892499     3.017390       104.586667  13.703333       0.596667  11853.853167
2006-09-30         7079.684433        871.376367      0.629744     0.941318     3.300809       104.690000  13.080000       0.520333  11888.659833
2006-12-31         7126.533033        890.780333      0.595792     0.892584     2.965914       105.166667  11.190000       0.776667  12668.453100
Feel free to ask any further questions or request additional analysis!
Get started with Vizly