text_plain_output_1.png
from scipy.stats import ttest_1samp, mannwhitneyu, shapiro, norm, t, kstest, shapiro

import pandas as pd

SHEET_ID = '10DM_ZqwV6CvOryD6u3pYHb5scjEfiwfkitUGTCG8l7Y'
SHEET_NAME = 'AAPL'
url = f'https://docs.google.com/spreadsheets/d/{SHEET_ID}/gviz/tq?tqx=out:csv&sheet={SHEET_NAME}'
df = pd.read_csv(url, decimal=',')

df_retention_ab = df.groupby('version').agg({'userid': 'count', 'retention_1': 'mean', 'retention_7': 'mean', 'sum_gamerounds': 'sum'})
df_retention_ab

print(kstest(df['sum_gamerounds'], 'norm'))