TDMS file read data in python

Question

During the project, I had to deal with a TDMS file. I'm asking because the file could not be read immediately.

My Goal: Perform analysis by converting TDMS file into DataFrame format

First attempt, -Perform TdmsFile open using npTdms package. -Converts to read_data() to execute pd.DataFrame command.

from nptdms import TdmsFile, TdmsWriter, ChannelObject, GroupObject
filenameS = "ex.tdms"
tdms_file = TdmsFile(filenameS)

[enter image description here][1]

So I succeeded in loading using TdmsFile.open() command.

But I tried read_data() on the second attempt and checked the error.

csv_merge = pd.DataFrame()
for i in tdms_file.group_channels('Analog Data'):
temp = i.read_data()
csv_merge = pd.concat([csv_merge, pd.DataFrame({i.channel: temp})], axis=1)

enter image description here

Last attempt,

tdms_file = TdmsFile.open(filenameS)
df = tdms_file.as_dataframe()

enter image description here

can you post link to you tdms file? – Zaraki Kenpachi Jul 24 '20 at 06:15 — Zaraki Kenpachi, Jul 24 '20 at 06:15
Sent a Google Drive link, is it downloaded? – Okgukui Jul 24 '20 at 06:24 — Okgukui, Jul 24 '20 at 06:24

score 0 · Accepted Answer · answered Jul 24 '20 at 06:48

0

Here you go =^..^=

from nptdms import TdmsFile
import pandas as pd

# load file
tdms_file = TdmsFile('20200609_130131.69.tdms')
# show groups
groups_data = tdms_file.groups()
print(groups_data)
# show channels
channels_data = tdms_file['group name'].channels()
print(channels_data)
# show data in channel
selected_data = tdms_file['group name']['channel name']
print(selected_data.data)

# load into df
df = pd.DataFrame(data=selected_data.data)

df output:

0  0.000000
1  0.111111
2  0.222222
3  0.333333
4  0.444444
5  0.555556
6  0.666667
7  0.777778
8  0.888889
9  1.000000

answered Jul 24 '20 at 06:48

Zaraki Kenpachi

4,664
2
9
29

I just opened the script and an error occurred. I put an error code in the answer. Can you confirm? – Okgukui Jul 24 '20 at 07:10
@Okgukui i don't know what group names and channels are inside file, i just use default. – Zaraki Kenpachi Jul 24 '20 at 07:12
@Okgukui will by nice if you can accept my answer and give vote up for that :) – Zaraki Kenpachi Jul 24 '20 at 07:28

score 0 · Answer 2 · answered Jul 24 '20 at 07:09

0

I do not know..

so, I did it using the TdmsFile.open() command. Then an error occurred

answered Jul 24 '20 at 07:09

Okgukui

13
2

TDMS file read data in python

2 Answers2