reshape.py

# -*- coding: utf-8 -*-
"""
Created on Wed Apr  3 00:47:42 2019

@author: coban
"""
import pandas as pd
import numpy as np


#path verilirken adres yolunun başına r harfi konulması gerekiyor..
data_all = pd.read_excel(r"C:\Users\coban\Desktop\dp1.xlsx")

data_truncated = data_all[["IDENTIFIER", "MEASUREPOINT", "RES_MEASURE"]]

data_ids = np.array(data_truncated["IDENTIFIER"].unique())

#columns_ measure points
columns_measure = data_truncated.iloc[:, 1].values

column_df = np.unique(columns_measure)

#res_measures
res_measures = np.matrix(data_truncated.iloc[:, 2].values)
res_measures = res_measures.reshape([data_ids.shape[0], column_df.shape[0]])

#final matrix
final = pd.DataFrame(res_measures, index = data_ids, columns = column_df)