Python Pandas

Working with excel

import pandas as pd
f="bar plot-summary.xlsx"
xls = pd.ExcelFile(f)
xls.sheet_names
import scipy.stats
writer = pd.ExcelWriter('barplot_data_with_pvalue.xlsx', engine='xlsxwriter')
for s in xls.sheet_names:
    ## calculate p-value
    df = pd.read_excel(f,sheet_name=s,header=None)
    out = [""]
    for i in range(1,df.shape[1]):
        x=scipy.stats.ttest_ind(df[0].tolist(),df[i].tolist()).pvalue
        out.append(x)
    df.loc["P-value"] = out
    df.to_excel(writer, sheet_name=s)
writer.save()

code @ github.