Website is: https://api.chucknorris.io/
Alright, let's see what we can do:
This is a web source, no authentication needed,so:
Just connect aaand..
Convert to columns in table and keep only the value column which is the joke.
Now for the categories:
Let's make a summarized a table:
Profit_Table =
SUMMARIZECOLUMNS(
Orders[State],
Orders,
"Profit by state", sum(Orders[Profit])
)
Now, we have a separate excel file with 2 values
Let's make our summarized table use this profit value.
Profit_Acceptable =
var…
with data_21 as (select * from (select country_region, date as date_21, confirmed as confirmed_21, deaths as deaths_21,LAG(confirmed, 1) OVER (PARTITION BY country_region ORDER BY date ASC) AS prev_day_21,confirmed - LAG(confirmed, 1) OVER (PARTITION BY country_region ORDER BY date ASC) as…
Step 1: Turn on performance analyzer and select the analyze this visual option.
After that, performance analyzer adds some lines:
Click copy query and paste anywhere:
And you see, there is the distinct value on it. Let's add something unique, like the orderID:
These are auto-generated in…
So the basics, nothing hard here:
shape()
drop()
[['Select1', 'Select2']]
isnull()
sum()
info()
head()
query()
Let's see the metadata first
SELECT column_name, data_type, descriptionFROM `bigquery-public-data`
.austin_311.
INFORMATION_SCHEMA.COLUMN_FIELD_PATHSWHERE table_name="311_service_requests"
Let's see how many years this database encompasses:
Looks like a lot of time.
As the dataset…
