df = pd.read_csv("MBV2rawdata.csv") #csv file with all the data
cpid = df.CPID.unique() # get unique IDs
xnp = df.to_numpy()
xval = xnp[:,2] # only need the values in column 2 of the dataframe
xrs = np.reshape(xval, (round(len(df)/len(cpid)), len(cpid)))

import pandas as pd
import numpy as np
# read the csv file into a dataframe
df = pd.read_csv('frame.csv')
#create 3 dataframes for the 3 letters
dfA = df[df.iloc[0] == 'a']
dfB = df[df.iloc[0] == 'b']
dfC = df[df.iloc[0] == 'c']
#now combine the dataframes
dfA['b'] = dfB
dfA['c'] = dfC

# read csv into dataframe
df = pd.read_csv("MBV2rawdata.csv") #CPID, Date, Value, Class

# I need this in the format Date, CPID#1, CPID#2, ... , CPID#n, Class


cpid = df.CPID.unique()


sf = df.Date[df.CPID == 24021] #Sf is the newly created dataframe

sf = pd.DataFrame(sf)


i=0
for colname in cpid:
    col = pd.DataFrame(df.Value[df.CPID==colname]) #get the column from df   
    for j in range(len(col)):   #have to reindex col to align with sf's index
        col.rename(index = { j + len(col)*i : j}, inplace=True)
    sf.insert(i+1, colname, col, True) #add col to sf
    i+=1


sf['Class']=df.Class[df.CPID == 24021] # add the 'Class' vlaues to sf