Skip to content
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.