CATEGORIA CLIENTES
Run to view results
The table has been created, showing the total `principal_amount` and its value in USD for each country.
import pandas as pd
# Perform the merge on 'client_uuid'
merged_df = pd.merge(df_30, df_34, on='client_uuid', how='inner')
# Deduplicate client_uuid
merged_df = merged_df.drop_duplicates(subset=['client_uuid'])
# Select the required columns, organized as instructed
result_df = merged_df[['source_country', 'client_uuid', 'tul_code', 'resized_at', 'current_limit']]
result_df
Run to view results