@@ -0,0 +1,900 @@
+import pandas%0Afrom collections import defaultdict%0A%0Arppa_file = 'data/TableS1-Split.xlsx'%0A%0Acell_lines = %5B'C32', 'COLO858', 'K2', 'LOXIMVI', 'MMACSF', 'MZ7MEL',%0A              'RVH421', 'SKMEL28', 'WM115', 'WM1552C'%5D%0A%0Adef read_rppa_data(fname=rppa_file):%0A    data = %7B%7D%0A    for cell_line in cell_lines:%0A        data%5Bcell_line%5D = %7B%7D%0A        # Read both the median and the std sheet for each cell line%0A        for data_type, postfix in (('median', ''), ('std', '-std')):%0A            # Handle unpredictable number of extra rows before the actual%0A            # header row.%0A            i = 0%0A            while True:%0A                df = pandas.read_excel(fname, sheetname=(cell_line + postfix),%0A                                       skiprows=i, header=0)%0A                if df.columns%5B0%5D == 'Drug':%0A                    break%0A                i += 1%0A            data%5Bcell_line%5D%5Bdata_type%5D = df%0A    return data%0A

Read in RPPA medians and stds