Import the complete waveform of the oscilloscope signal into advanced data analysis software for calculation[Copy link]
To learn how to import the complete data of the Macosin oscilloscope signal into MATLAB for analysis, we must first learn how to completely export the oscilloscope signal data. The oscilloscope can save the analog channel or math channel waveform to a local or USB drive, and the file type can be selected as WAV, CSV or BIN.
WAV is the first way to save data files. It samples the waveform data displayed by the current channel and saves it as a binary file. Data saved in WAV format to local or external storage can be opened, viewed, and scaled on this machine through the REF reference channel.
The following figure shows the display result of saving channel 1 as the reference channel. It can be seen that the data of the reference channel is 87.5K, which is quite different from the original 28M data. Moreover, the data cannot be calculated and analyzed.
CSV is the second way to save data files. It will save the waveform data of the current channel of the oscilloscope in CSV format to the internal storage of the oscilloscope or the external storage USB flash drive. CSV is a comma separated value file format. Its file stores table data in plain text. It will convert the required binary data into ASCII code and save it as ASCII code data. It can be opened with software such as Excel, Access or text files. The oscilloscope itself cannot be called. The following figure is the interface after opening the first waveform graph with Excel and saving it as a CSV file. The lower part is a line graph synthesized with D and E as coordinates:
But one thing to note here is that the signal data of the first waveform is 28M, but the exported excel only has 87,500 rows of data. In fact, whether it is WAV format or CSV format, the data obtained is not the complete 28M, but the result obtained by collecting part of the complete data. 28M data should have 28,000,000 rows of data, which is 320 times different from the exported CSV.
For some users who need to save a screen of 28M waveform data completely, the oscilloscope has another format, which is the BIN format. It takes about 2 seconds to save a CSV file containing 87,500 lines of data. If you want to save a CSV file with 28M data, do you have to wait for the oscilloscope for half a day? The BIN format solves this problem. It also only takes a few seconds for the oscilloscope to save the BIN format. Then we can use the official BIN to CSV software of the Macoshine oscilloscope to transfer the computing pressure to the computer. The entire operation process takes less than 30 seconds.
In this way, we get the complete 28 million rows of data, but such a huge amount of data cannot be processed by Excel, as Excel itself can only create a maximum of 1,048,576 rows of data.
Therefore, to process big data like this, we need to use more professional software, such as Matlab. We open Matlab, choose to import data, select the csv file containing complete data, and you can see that 28M of complete data is imported into Matlab. After importing the selected time and numerical data into the Matlab workspace, you can perform various scientific data analysis and calculations.
As shown in the figure above, a waveform is generated based on the variables in the workspace (i.e. the time and numerical data just exported) to perform complex scientific operations on the data, and Simulink is used to perform FFT analysis on the signal. In addition to Matlab, mathematical software such as Mathematica and Maple can also perform data calculation and analysis. If you are interested, you can learn more about it yourself.