# lets make it more interestingdf.to_excel("export.xlsx") # export dataframe to exceldf['region_name'].value_counts()df['hafl_all'] = df['res'] / 2 # create new columndf.head()store = pd.read_excel('//content//Sample-Superstore.xls',…

So we have this dataset about crimes in London. Let's calculate what was the % of crimes categorised as 'Violence Against the Person' compared to all the crime types. ,round(sum(case when major_category = 'Violence Against the Person' then 1 else 0 end)/sum(case when major_category =…

function loopit_percentages() { var percentcols = ['D', 'E','F'] for (var k = 0; k<= percentcols.length -1; k++) { for (var i = 1; i<=20;i++) { var rng = percentcols[k] + i.toString() Logger.log(rng) SpreadsheetApp.getActiveSheet().getRange(rng).setNumberFormat("0.00%") }}} function…