In [1]:

    

import numpy as np
import pandas as pd


    

In [2]:

    

metadata = 'whitelist_metadata.csv'
whitelist = 'whitelist.txt'


    

In [3]:

    

srt = pd.read_csv(metadata,header=None).groupby(by=0).mean().sort_index(by=[1])
srt.to_csv(metadata,header=None)
pd.Series(pd.Series(srt.index).append(pd.read_csv(whitelist,header=None)).iloc[:,0].unique()).to_csv(whitelist,index=False)


    

    




/home/hoffmaj2/anaconda3/lib/python3.5/site-packages/ipykernel/__main__.py:1: FutureWarning: by argument to sort_index is deprecated, pls use .sort_values(by=...)
  if __name__ == '__main__':

In [ ]: