Analyzing unicorn company data

1 hidden cell

DataFrameas

df

variable

-- List the 5 companies that attracted the most funding
SELECT * 
FROM public.companies
LIMIT 5

DataFrameas

df1

variable

SELECT * FROM public.funding
LIMIT 5;

DataFrameas

df2

variable

SELECT * FROM public.industries
LIMIT 5;

DataFrameas

df3

variable

SELECT * 
FROM public.companies
LEFT JOIN public.funding ON public.companies.company_id = public.funding.company_id
LEFT JOIN public.industries ON public.companies.company_id = public.industries.company_id

usa = df3[df3['country'] == 'United States']

city = usa.value_counts('city')
top_city = city[city >= 3]
print(top_city)

Open the video in a new tab