data_processor.cpython-313.pyc•3.94 kB
�
څh� � � � S SK rS SKJr S SKrS SKJr S\S\R 4S jr S\R S\4S jr
S S\R S\S \S\4S
jjr g) � N)�datetime� file_path�returnc �2 � [ R " U 5 nU$ )N)�pd�read_csv)r �dfs �5C:\MCP Code crunch\mcp-server\utils\data_processor.py�load_csvr s � � ���Y� �B�
�I� r c �� � S[ U 5 SSR U R 5 S3nSU R ; a8 U S R 5 nUSUS S3-
nUS U S R 5 S S3-
nS
U R ; ai U R S
5 S R 5 R
S S 9R S
5 nUS-
nUR 5 H u pEUSU SUS S3-
nM SU R ; ai U R S5 S R 5 R
S S 9R S
5 nUS-
nUR 5 H u puUSU SUS S3-
nM U$ )NzRows: z
Columns: z, z
�Costz
Total Cost: $z.2f�
zAverage Cost: $� ServiceNameF�� ascending� z
Top 5 Services by Cost:
z- z: $�
ServiceRegionz
Top 5 Regions by Cost:
) �len�join�columns�sum�mean�groupby� sort_values�head�items)r �summary�
total_cost� top_services�service�cost� top_regions�regions r
�summarize_datar%
s� � ��s�2�w�i�{�4�9�9�R�Z�Z�+@�*A��F�G� �������Z�^�^�%�
��]�:�c�"2�"�5�5���_�R��Z�_�_�%6�s�$;�2�>�>����
�
�"��z�z�-�0��8�<�<�>�J�J�UZ�J�[�`�`�ab�c� ��0�0�� )� /� /� 1�M�G� ��G�9�C��S�z��4� 4�G� 2� �"�*�*�$��j�j� �1�&�9�=�=�?�K�K�V[�K�\�a�a�bc�d� ��/�/�� '� -� -� /�L�F� ��F�8�3�t�C�j��3� 3�G� 0� �Nr �x_col�y_colc � � [ R R U5 ( d [ R " U5 [ R
" 5 R
S5 S3n[ R R X45 nUS; a� U R U5 U R 5 R SS9R S5 R 5 n[ R " SS9 [ R " Xa Xb 5 [ R " S S
S 9 [ R" " U S U 35 [ R$ " 5 [ R& " U5 [ R( " 5 U$ U R+ S
XSSS9 [ R$ " 5 [ R& " U5 [ R( " 5 U$ )Nz %Y%m%d%H%M%Sz
_chart.png)r r � ServiceTypeFr �
)r* � )�figsize�- �right)�rotation�haz by �bar)�kind�x�y�legendr, )�os�path�exists�makedirsr �now�strftimer r r r r � reset_index�plt�figurer1 �xticks�title� tight_layout�savefig�close�plot)r r& r' �
output_dir�filenamer7 �
chart_datas r
�generate_chartrH ! sF � �
�7�7�>�>�*� %� %�
� � �J� ��,�,�.�)�)�.�9�:�*�E�H�
�7�7�<�<�
� -�D�
�?�?��Z�Z��&�u�-�1�1�3�?�?�%�?�P�U�U�VX�Y�e�e�g�
� �
�
�7�#� ���
�!�:�#4�5� �
�
�B�7�+� � � �U�G�4��w�'�(� ���� � � �D�� � � � � �K� ���U�e�U�G��L� ���� � � �D�� � � � � �Kr )zreports/charts) �pandasr �matplotlib.pyplot�pyplotr= r6 r �str� DataFramer r% rH � r r
�<module>rO se �� � � � ��� �� � � ��r�|�|� �� �.�r�|�|� �C� �� �]`� r