quote:

---

Originally posted by easwar

Hi Andrey,

Currently the GUI does not support this. We can however provide Python code to import the data.

Can you send us a set of files or a link to a zip file for a set of files?

If sending the files, you can attach to a new ticket as a zip file:
https://www.originlab.com/restricted/support/newticket.aspx?c=3

Thank you,

Easwar
OriginLab

---

import originpro as op
import pandas as pd
import numpy as np


fileList = ['AlK_1','AlK_2']
data = None
for file in fileList:
    df = pd.read_csv(f'C:\\Users\\yiming\\Documents\\OriginLab\\User Files\\{file}.csv', index_col=0, header=3)
    dt = np.transpose(df.values)
    dd = np.expand_dims(dt, axis=0)
    if data is None:
        data = dd
    else:
        data = np.concatenate((data,dd), axis=0)  

print(data.shape)
ws=op.new_sheet('m','[Book1]BTest')
ws.from_np(data)

for i, nm in enumerate(fileList):
    ws.set_label(i, nm)

quote:

---

Originally posted by YimingChen

Can you try the Python code below?

import originpro as op
import pandas as pd
import numpy as np


fileList = ['AlK_1','AlK_2']
data = None
for file in fileList:
    df = pd.read_csv(f'C:\\Users\\yiming\\Documents\\OriginLab\\User Files\\{file}.csv', index_col=0, header=3)
    dt = np.transpose(df.values)
    dd = np.expand_dims(dt, axis=0)
    if data is None:
        data = dd
    else:
        data = np.concatenate((data,dd), axis=0)  

print(data.shape)
ws=op.new_sheet('m','[Book1]BTest')
ws.from_np(data)

for i, nm in enumerate(fileList):
    ws.set_label(i, nm)

James

---

import originpro as op
import pandas as pd
import numpy as np


fileList = ['AlK_1','AlK_2']
data = None
for file in fileList:
    df = pd.read_csv(f'C:\\Users\\yiming\\Documents\\OriginLab\\User Files\\{file}.csv', index_col=0, header=3)
    df = df.dropna(axis=1)
    
    # get x range
    xvals = [int(i) for i in df.columns.tolist()]
    x1 = xvals[0]
    x2 = xvals[len(xvals)-1]
    
    # get y range
    yvals = [int(j) for j in df.index.tolist()]
    y1 = yvals[0]
    y2 = yvals[len(yvals)-1]
    
    # build input 2D array    
    dt = np.transpose(df.values)
    dd = np.expand_dims(dt, axis=0)
    if data is None:
        data = dd
    else:
        data = np.concatenate((data,dd), axis=0)  

mb = op.new_book('m','Long_Name')
mb.name = 'Short_Name'
ms = mb[0]

ms.from_np(data.astype('float'))
ms.xymap = y1, y2, x1, x2
ms.show_thumbnails()

for i, nm in enumerate(fileList):
    ms.set_label(i, nm)

quote:

---

Originally posted by YimingChen

Please see the code below that has addressed question 1,2,3. For 4) what do you mean by transpose the sheet? Current code transposes the matrix of each file before being put to a matrix object.

import originpro as op
import pandas as pd
import numpy as np


fileList = ['AlK_1','AlK_2']
data = None
for file in fileList:
    df = pd.read_csv(f'C:\\Users\\yiming\\Documents\\OriginLab\\User Files\\{file}.csv', index_col=0, header=3)
    df = df.dropna(axis=1)
    
    # get x range
    xvals = [int(i) for i in df.columns.tolist()]
    x1 = xvals[0]
    x2 = xvals[len(xvals)-1]
    
    # get y range
    yvals = [int(j) for j in df.index.tolist()]
    y1 = yvals[0]
    y2 = yvals[len(yvals)-1]
    
    # build input 2D array    
    dt = np.transpose(df.values)
    dd = np.expand_dims(dt, axis=0)
    if data is None:
        data = dd
    else:
        data = np.concatenate((data,dd), axis=0)  

mb = op.new_book('m','Long_Name')
mb.name = 'Short_Name'
ms = mb[0]

ms.from_np(data.astype('float'))
ms.xymap = y1, y2, x1, x2
ms.show_thumbnails()

for i, nm in enumerate(fileList):
    ms.set_label(i, nm)

James

---

mb.add_sheet('sheet2')

quote:

---

Originally posted by YimingChen

Use this:

mb.add_sheet('sheet2')

James

---

MatrixBook = op.find_book('m')

quote:

---

Originally posted by cpyang

mb = op.find_book('m')

will give the the object for the active window if it is a matrix book, yes.

CP

---