Missing AV1451 Data in D1_D2?

[Andrew Cirincione]

Hello all,

Excuse me as I am new to ADNI and the biomedical community. Looking through the TADPOLE_D1_D2 csv document, it does not appear that there is any data for any of the patients for the AV1451 PET scans. What am I missing/not understanding here? Thanks for any help you are willing to provide.

Best,

Andrew Cirincione

[Razvan Marinescu]

It must be there! (I haven't checked right now, but off the top of my head - Neil & I assembled that dataset 3 years ago). 

You have to scroll a lot through the columns to the right, AV1451 should be around the very end. 

Also, if you open it with Linux through LibreOffice, it won't load the entire spreadsheet due to it's very big size, so you won't see it. You can see it if you open it with vim/emacs. 

Raz

[Neil Oxtoby]

AV1451 is in there, but there's not much because it was fully introduced in ADNI3 (D1_D2 is up to ADNI2).

Here's some python code to find the 89 non-empty rows of the AV1451 columns in TADPOLE_D1_D2.csv:

import pandas as pd, numpy as np
df = pd.read_csv("TADPOLE_D1_D2.csv",low_memory=False)
colz = [c for c in df.columns.tolist() if "1451" in c]

df_tmp = df.iloc[np.where((df[colz]==' ').sum(axis=1)==0)[0]][['RID','VISCODE','COLPROT','ORIGPROT']+colz].copy()

[Neil Oxtoby]

(P.S. @Raz: it was a bit more than 3 years ago...the submission deadline was 5 years ago! :-) )

[Razvan Marinescu]

Oh yes, you're right! Time flies.