My first workspace
  • AI Chat
  • Code
  • Report
    • Beta
    Spinner

    My first workspace

    In this workspace, we'll be exploring the relationship between total funding a company receives and its valuation.

    Unknown integration
    Data frameavailable as
    df
    variable
    SELECT * FROM companies INNER JOIN funding USING(company_id)
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    library(plotly)
plot_ly(data = df, x=~funding, y=~valuation, text = ~company, type = "scatter", mode = "markers")

    Existe una cierta relación entre...

    Unknown integration
    Data frameavailable as
    df2
    variable
    select continent, count(company) as number_companies, sum(valuation)/1000000000 as valor
from companies INNER JOIN funding USING(company_id)
where valuation > 0
group by continent
order by number_companies DESC
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    library(plotly)
plot_ly(data = df2, x=~continent, y = ~valor, text = ~valor, type = "bar")
    Unknown integration
    Data frameavailable as
    df3
    variable
    select year_founded, count(company_id) as companies_per_year
from dates INNER JOIN companies USING(company_id)
group by year_founded
order by companies_per_year DESC
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    Unknown integration
    Data frameavailable as
    df
    variable
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.

    ggplot(data = df3 , aes(x = year_founded, y = companies_per_year, group=continent)) +

    geom_line(aes(color=continent)) + facet_wrap(~continent)

    ggplot(data = df3 , aes(x = year_founded, y = companies_per_year)) + 
geom_col(linewidth=2, color="black", fill="blue") +
scale_x_continuous(breaks=seq(1910,2021,5)) +
scale_y_continuous(breaks=seq(0,170,10)) +
labs(x="Year of foundation", y="Number of companies founded per year")+
theme_bw()
    Unknown integration
    Data frameavailable as
    df
    variable
    select *
from product_emissions
limit 100;
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    Unknown integration
    Data frameavailable as
    df4
    variable
    select country, sum(carbon_footprint_pcf)/10000 as cfp
from product_emissions
group by country
order by cfp DESC
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    Unknown integration
    Data frameavailable as
    df5
    variable
    select industry_group, sum(carbon_footprint_pcf)/10000 as cfp
from product_emissions
where carbon_footprint_pcf > 10000
group by industry_group
order by cfp DESC
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.
    ‌
    ‌
    ‌
    Open the video in a new tab