Create a list of dictionaries with the past usage data
data = [
{'year': 2018, 'number_usage': 235446},
{'year': 2019, 'number_usage': 288847},
{'year': 2020, 'number_usage': 194249},
{'year': 2021, 'number_usage': 205100},
{'year': 2022, 'number_usage': 401755},
{'year': 2023, 'number_usage': 17841219}
]
# Create a DataFrame with the past usage data
df = pd.DataFrame(data)
# Train an ARIMA model
model = ARIMA(df['number_usage'], order=(1, 1, 1))
model_fit = model.fit()
# Make predictions for future years
future_years = [2024, 2025, 2026]
future_predictions = model_fit.forecast(len(future_years))[0]
# Create a DataFrame with the predicted future usage data
future_data = [
{'year': 2024, 'predicted_number_usage': future_predictions[0]},
{'year': 2025, 'predicted_number_usage': future_predictions[1]},
{'year': 2026, 'predicted_number_usage': future_predictions[2]}
]
future_df = pd.DataFrame(future_data)
print(future_df)
Q3JlYXRlIGEgbGlzdCBvZiBkaWN0aW9uYXJpZXMgd2l0aCB0aGUgcGFzdCB1c2FnZSBkYXRhCmRhdGEgPSBbCiAgICB7J3llYXInOiAyMDE4LCAnbnVtYmVyX3VzYWdlJzogMjM1NDQ2fSwKICAgIHsneWVhcic6IDIwMTksICdudW1iZXJfdXNhZ2UnOiAyODg4NDd9LAogICAgeyd5ZWFyJzogMjAyMCwgJ251bWJlcl91c2FnZSc6IDE5NDI0OX0sCiAgICB7J3llYXInOiAyMDIxLCAnbnVtYmVyX3VzYWdlJzogMjA1MTAwfSwKICAgIHsneWVhcic6IDIwMjIsICdudW1iZXJfdXNhZ2UnOiA0MDE3NTV9LAogICAgeyd5ZWFyJzogMjAyMywgJ251bWJlcl91c2FnZSc6IDE3ODQxMjE5fQpdCgojIENyZWF0ZSBhIERhdGFGcmFtZSB3aXRoIHRoZSBwYXN0IHVzYWdlIGRhdGEKZGYgPSBwZC5EYXRhRnJhbWUoZGF0YSkKCiMgVHJhaW4gYW4gQVJJTUEgbW9kZWwKbW9kZWwgPSBBUklNQShkZlsnbnVtYmVyX3VzYWdlJ10sIG9yZGVyPSgxLCAxLCAxKSkKbW9kZWxfZml0ID0gbW9kZWwuZml0KCkKCiMgTWFrZSBwcmVkaWN0aW9ucyBmb3IgZnV0dXJlIHllYXJzCmZ1dHVyZV95ZWFycyA9IFsyMDI0LCAyMDI1LCAyMDI2XQpmdXR1cmVfcHJlZGljdGlvbnMgPSBtb2RlbF9maXQuZm9yZWNhc3QobGVuKGZ1dHVyZV95ZWFycykpWzBdCgojIENyZWF0ZSBhIERhdGFGcmFtZSB3aXRoIHRoZSBwcmVkaWN0ZWQgZnV0dXJlIHVzYWdlIGRhdGEKZnV0dXJlX2RhdGEgPSBbCiAgICB7J3llYXInOiAyMDI0LCAncHJlZGljdGVkX251bWJlcl91c2FnZSc6IGZ1dHVyZV9wcmVkaWN0aW9uc1swXX0sCiAgICB7J3llYXInOiAyMDI1LCAncHJlZGljdGVkX251bWJlcl91c2FnZSc6IGZ1dHVyZV9wcmVkaWN0aW9uc1sxXX0sCiAgICB7J3llYXInOiAyMDI2LCAncHJlZGljdGVkX251bWJlcl91c2FnZSc6IGZ1dHVyZV9wcmVkaWN0aW9uc1syXX0KXQpmdXR1cmVfZGYgPSBwZC5EYXRhRnJhbWUoZnV0dXJlX2RhdGEpCgpwcmludChmdXR1cmVfZGYp