Data Analysis in Google Spreadsheet

 Chapter 1

=round(b2)  # ctl+enter for filling up the whole column.

=round(sqrt(B2)) # composite function for finding the sqrt and round the values. 

Basics of python IOP

if isinstance(object, type):

# this checks whether the the object belongs to the soecified type or not. mane oi object er type ta ki jeta braces er moddhe ase setai naki onno kichhu.

# isinstance(name, str) checks if name is an instance of a class str . name er datatype string e kina ta check kore. 

SQL Notes

 --We want to look at number of the charts created monthly by group of months

--then we will want to add another column to start counting the charts with the offset of 1 using lag(count(*),1) over timestamp

--we will want to calculate the difference of changes in the percentage format. 100*(count(*)- lag(count(*),1) over(order by timestamp)) / lag(count(*),1)

select date_trunc('month',timestamp) as date,

count(*) as count,

from events

where event_name = 'created charts'

group by  1

order by 1