parse_profilometer_xy_data.py

def parse_profilometer_xy_data(filename):
    
    

    df_header = pd.read_csv(filename, sep='\s+',header=None, nrows=7 )
    df_header = df_header.T
    df_header.columns = df_header.iloc[0]
    df_header = df_header.reindex(df_header.index.drop(0))
    name = df_header.Data
    x_resolution = df_header['X-Resolution'].astype('float').values
    y_resolution = 0.0001
    x_coord = df_header['X-Coord'].values
    y_coord = df_header['Y-Coord'].values
    
    # Data points
    df = pd.read_csv(filename, sep='\s+',header=0, skiprows=7)

    x = np.arange(len(df.Intermediate))*x_resolution
#     print(x)
    y = df['Normal']*y_resolution
#     plt.plot(x, y, label=file_i)

    return x,y


for d in data:
    filename = filename = d['filename']

    x,y = parse_profilometer_xy_data(filename)
    break
    
    
x_coord, y_coord,x,y

plt.plot(x,y)