CSV file column names

Ali Rasouli on 25 Oct 2021 (Edited on 25 Oct 2021)
Latest activity Reply by Ali Rasouli on 25 Oct 2021

I currently have my ThingSpeak log temp, airflow velocity raw and airflow velocity filtered. The column names show as field1, field 2 and field 3. Is there a way for me to change field1 to temperature? Thanks

Christopher Stapels
Christopher Stapels on 25 Oct 2021 (Edited on 25 Oct 2021)

Unfortunately the CSV title names are fixed as the field number names (not your set names). You can use the read channel info API to get the field labels. Can I help you do whatever you are doing with the CSV file in MATLAB? Then you won't have to export it at all. In MATLAB code, you can use thingSpeakRead to get the data with column names. Then you can analyze it in MATLAB analysis and then plot it in a MATLAB visualization.

Ali Rasouli
Ali Rasouli on 25 Oct 2021

Hi Christopher, I am logging sensor values on Thingspeak for our data scientist to read and analyze. He asked to have the column names changed to the actual name. Thanks

Christopher Stapels
Christopher Stapels on 25 Oct 2021

Thanks for the information. Please tell your data scientist that they can use MATLAB right in ThingSpeak to analyze the data. Or if they have desktop MATLAB its easy to download data there with the same functions. We love to hear about ThingSpeak applications, can you tell me what you are measuring airflow for?

Ali Rasouli
Ali Rasouli on 25 Oct 2021

Thanks for the reply. We are measuring the air flow inside our vertical farming module.

Tags

No tags entered yet.