Skip to content

Instantly share code, notes, and snippets.

@jing-jin-mc
jing-jin-mc / Pandas - Working with datetime date.ipynb
Created Dec 3, 2020
Pandas - Working with datetime data.ipynb
View Pandas - Working with datetime date.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View Pandas - Merge and reshaping.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View Pandas - Select Data.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View user_deletion.gs
function deleteUser() {
var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = activeSpreadsheet.getSheetByName('Main');
var resultsheet = activeSpreadsheet.getSheetByName('Result');
var userInputs = sheet.getRange("A3:B").getValues();
var webPropertyId = String(userInputs[0][0]);
var numClients = userInputs[0][1]
for (var i = 0; i<numClients;i++){
var typeOfId = String(userInputs[2+i][1]);
@jing-jin-mc
jing-jin-mc / A_Simple_AB_test.ipynb
Created Dec 16, 2018
Get AB test data and do a simple AB test Analysis on the result
View A_Simple_AB_test.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jing-jin-mc
jing-jin-mc / AB_Test_Query.ipynb
Created Dec 10, 2018
BigQuery Example for getting AB test data
View AB_Test_Query.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jing-jin-mc
jing-jin-mc / Automate_User_Deletion.ipynb
Created Dec 6, 2018
Get Data from Analytics Reporting API, Connect Jupyter Notebook with Spread Sheet
View Automate_User_Deletion.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View user_deletion_api.gs
function myFunction() {
var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = activeSpreadsheet.getSheetByName('Main');
var resultsheet = activeSpreadsheet.getSheetByName('Result');
var userInputs = sheet.getRange("A3:B").getValues();
var webPropertyId = String(userInputs[0][0]);
var numClients = userInputs[0][1]
for (var i = 0; i<numClients;i++){
var typeOfId = String(userInputs[2+i][1]);
@jing-jin-mc
jing-jin-mc / Google_Drive.ipynb
Created Dec 3, 2018
Connect Jupyter Notebook with Google Sheet
View Google_Drive.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jing-jin-mc
jing-jin-mc / Get_ClientID_List.ipynb
Created Dec 3, 2018
Google Analytics Reporting API
View Get_ClientID_List.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
You can’t perform that action at this time.