Chittrarasu/Population_FastAPI
0
1�
2 y�g7 � �p � S SK rS SKJr \R " S5 r\R " S5 \R S5 R SSS S3S S S
S 4S
S 4S9R 5 r
\
S \
S - \
S' \R " S5 S rS rg! \ a r\R " S\ 35 SrCN�SrCff = f)� N)�loggerzdata/world_population.csvz CSV file loaded successfully.zError loading CSV file: � Continent)�Country�count)�4Population�sum)r �mean)�Arear )r �max)r �minr c �H � [ R U R 5 S4 $ �Nr )�df�loc�idxmax��xs �4C:\chitu\population_api\backend\population_pandas.py�<lambda>r � � �B�F�F�1�8�8�:�y�;P�4Q� c �H � [ R U R 5 S4 $ r )r r �idxminr s r r r r r )�Total_Countries�Total_Population�Average_Population�5Total_Area�max_population�min_population�Country_Max_Population�Country_Min_Populationr r �Population_DensityzData processing completed.c �\ � [ R " S5 [ S R 5 $ )z!Returns a list of all continents.zFetching all continents.r )r �info�continent_stats�tolist� r r �get_continentsr( s# � �6�K�K�*�+� �;� '� .� .� 0�0r c �� � [ R " SU 35 [ [ S U :H R 5 nUR ( a [ R7 " SU 35 0 $ UR
5 $ )z,Returns statistics for a specific continent.z Fetching data for continent: r z No data found for continent: )r r$ r% �squeeze�empty�warning�to_dict)� continent�results r �get_continent_datar0 $ s` � �8�K�K�/� �{�;�<�
�_�[� 9�Y� F�
G�
O�
O�
Q�F�
�|�|����6�y�k�B�C�� � �>�>� �r )�pandas�pd�backend.loggerr �read_csvr r$ � Exception�e�error�groupby�agg� reset_indexr% r( r0 r' r r �<module>r; s� �� � !�1� ���0� 1�B�9�K�K�/�0�10 �*�*�[�)�-�-�(�*�-� �(�(� (�*Q�R� (�*Q�R� .� � �+�-� � �&�'�/�,�*G�G� �$� %� � � � (� )�1�11 ��7 � 1�12�L�L�+�A�3�/�0�0��1�s �$B �B5�B0�0B5