Country with highest percentage of rich - better solution?

Python
1

Hi - Finally solved this after hours :(. Any better / cleaner solution thanks? I am sure there are much better ways.

Thanks

 # What country has the highest percentage of people that earn >50K?
    highest_earning_countries = df[df["salary"].str.contains(">")]
    
    highest_earning_countries = highest_earning_countries["native-country"].value_counts().sort_index(ascending=True).to_frame()
    # highest_earning_countries.rename(columns={"native-country": "rich-count"})
  
    # country group count
    highest_earning_countries["country-counts"] = df["native-country"].value_counts().sort_index(ascending=True)
    # print(highest_earning_countries)
    highest_earning_countries["percentages"] = round (100 * (highest_earning_countries["native-country"] / highest_earning_countries["country-counts"]), 1)

    #print(highest_earning_countries)

    highest_earning_country = highest_earning_countries["percentages"].idxmax()
    highest_earning_country_percentage = highest_earning_countries["percentages"].max()
2

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.