📅 2023-09-23 — Session: Extended DataFrame for Future Projections
🕒 18:35–18:40
🏷️ Labels: Data Analysis, Dataframe, Projection, Python, Pandas
📂 Project: Dev
⭐ Priority: MEDIUM
Session Goal
The session aimed to project future values in a DataFrame by calculating the mean of a specified column and extending the DataFrame for future analysis.
Key Activities
- Developed a systematic approach for projecting future values in a DataFrame based on the mean calculation of the ‘Monto_hoy’ column.
- Outlined the process for extending the DataFrame for six months using the calculated mean and a specified factor.
- Discussed the need for merging the extended DataFrame with a CPI DataFrame to obtain index values for accurate projections.
- Provided step-by-step Python code for extending the DataFrame’s time period, merging with CPI data, and performing necessary data manipulations using Pandas.
- Corrected the Python code by replacing deprecated methods with current best practices.
Achievements
- Successfully outlined and implemented a method for projecting future values in a DataFrame.
- Developed and corrected Python code for extending and merging DataFrames using Pandas.
Pending Tasks
- Obtain the CPI DataFrame to complete the merging process and finalize the future projections.