AWS cost analysis
Analysis of aws_usage.csv which contains a detailed dataset of AWS usage in a SaaS company. The dataset includes various AWS services, usage metrics, costs, and departmental details.
Summary statistics: Provide a summary of key statistics such as total costs, average usage.
Cost analysis: Analyze the cost trends over time. Are there any particular months or seasons with higher costs?
Time series analysis: How does the usage of AWS services fluctuate over time? Are there any noticeable trends or seasonal patterns in the data?
department
service
Summary statistics
Provide a summary of key statistics such as total costs, average usage.
12.0 - 9788.0
2.8750335023937224 - 12345678909.0
count
122
122
unique
nan
nan
top
nan
nan
freq
nan
nan
mean
4902.442623
12345678904
std
2769.996005
2.875033502
min
12
12345678900
25%
2544.75
12345678902
50%
4514
12345678905
75%
7379.25
12345678907
11 rows, showing
per page
Page of 2
Cost analysis
Analyze the cost trends over time. Are there any particular months or seasons with higher costs?
Time series analysis
How does the usage of AWS services fluctuate over time? Are there any noticeable trends or seasonal patterns in the data?
/shared-libs/python3.9/py/lib/python3.9/site-packages/_plotly_utils/basevalidators.py:106: FutureWarning:
The behavior of DatetimeProperties.to_pydatetime is deprecated, in a future version this will return a Series containing python datetime objects instead of an ndarray. To retain the old behavior, call `np.array` on the result