Often I need to transform several columns of data into rows of aligned values in a matrix, for multivariate analysis. So randomly ordered values in the same sample are arranged/aligned into the corresponding column. How can I conduct this automatically?
you can do it in Python easily:
import pandas as pd
dic = {'Sample_1': [1,5],'Sample_2': [2,3,4,5],'Sample_3': [1,3,5]}
min_val=min(min(dic.values()))
max_val=max(max(dic.values()))
def f(x,k):
if x in dic[k]:
return x
else:
return 'NaN'
dic_New = {k: [] for k in dic.keys()}
for k in dic.keys():
for j in range(min_val,max_val+1):
dic_New[k].append(f(j,k))
print(dic)
{'Sample_1': [1, 5], 'Sample_2': [2, 3, 4, 5], 'Sample_3': [1, 3, 5]}
print(dic_New)
{'Sample_1': [1, 'NaN', 'NaN', 'NaN', 5], 'Sample_2': ['NaN', 2, 3, 4, 5], 'Sample_3': [1, 'NaN', 3, 'NaN', 5]}
df=pd.DataFrame.from_dict(dic_New,orient="index")
print(df)
0 1 2 3 4 Sample_1 1 NaN NaN NaN 5 Sample_2 NaN 2 3 4 5 Sample_3 1 NaN 3 NaN 5
change 'NaN' with the values you are interested
- Badges
- Science topic
- Similar topics
- Computer Science and Engineering
- Artificial Intelligence