0

grouped_df = unicorn_df.groupby(['Continent','Industry']).count() grouped_df['Company']

the result is like this : Continent Industry
Africa Consumer & retail 1 ** Fintech 3** Mobile & telecommunications 1 Asia Artificial Intelligence 25 Auto & transportation 19 Consumer & retail 12 Cybersecurity 8 Data management & analytics 4 ** E-commerce & direct-to-consumer 57** Edtech 20 Fintech 43 Hardware 20 Health 13 Internet software & services 36 Mobile & telecommunications 21 Other 14 Supply chain, logistics, & delivery 28 Travel 7 Europe Artificial Intelligence 7 Auto & transportation 8 Consumer & retail 3 Cybersecurity 2 Data management & analytics 6 E-commerce & direct-to-consumer 16 Edtech 2 ** Fintech 53** Hardware 5 Health 9 Internet software & services 19 Mobile & telecommunications 4 Other 14 Supply chain, logistics, & delivery 8 Travel 5 NorthAmerica Artificial Intelligence 56 Auto & transportation 10 Consumer & retail 14 Cybersecurity 48 Data management & analytics 35 E-commerce & direct-to-consumer 30 Edtech 10 Fintech 142 Hardware 15 Health 73 ** Internet software & services 168** Mobile & telecommunications 13 Other 36 Supply chain, logistics, & delivery 28 Travel 2

I only want to show the name of continent and industry that have the highest number of company, what should I do?

enter image description here

What code should I write to get only the continent and industry who has highest number of company?

0 Answers0