Skip to content
Analyzing unicorn company data
  • AI Chat
  • Code
  • Report
    • Unknown integration
    DataFrameavailable as
    df
    variable
    -- List the 5 companies that attracted the most funding
SELECT * 
FROM public.companies
LIMIT 5
    Unknown integration
    DataFrameavailable as
    df1
    variable
    SELECT * FROM public.funding
LIMIT 5;
    Unknown integration
    DataFrameavailable as
    df2
    variable
    SELECT * FROM public.industries
LIMIT 5;
    Unknown integration
    DataFrameavailable as
    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