Скачать или смотреть How to Efficiently Read Serial Data from Multiple Arduino ADCs Using Python

Learn how to read serial data from more than one Arduino ADC and save it in a clean CSV format for easy analysis in Excel.
---
This video is based on the question https://stackoverflow.com/q/64193693/ asked by the user 'Miron' ( https://stackoverflow.com/u/14388625/ ) and on the answer https://stackoverflow.com/a/64201694/ provided by the user 'ron_olo' ( https://stackoverflow.com/u/9826045/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to read Serial data with Python from more then one Arduino ADC?

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Efficiently Read Serial Data from Multiple Arduino ADCs Using Python

If you're venturing into the world of data collection using Arduino boards, you may quickly find yourself needing to capture and process serial data. Especially if you're a beginner in Python, you might encounter some pitfalls when trying to save this data into a CSV file for further analysis. One common issue arises when you notice that the values you're trying to record are not formatted in the way you need. In this guide, we will explore how to read serial data from more than one Arduino ADC and save it in a structured CSV file, which can then be easily opened in Excel.

The Challenge

While trying to read serial data from your Arduino, you might find that the output is formatted with quotation marks that complicate your efforts to split and translate the data into separate columns in a CSV file. A beginner-friendly example of the output may look something like this:

[[See Video to Reveal this Text or Code Snippet]]

This specific format can lead to issues when you want to analyze the data, as you cannot separate the numbers correctly.

Solution Overview

To tackle this issue, we need to make adjustments to both the Arduino code and the Python script that handles the serial data. Here are the steps we’ll take:

Modify Arduino code to ensure proper serial data output.

Update the Python script to correctly read, parse, and format this data for CSV.

Step 1: Modify the Arduino Code

Here is a basic setup for your Arduino code:

[[See Video to Reveal this Text or Code Snippet]]

This section simply prints the two sensor values separated by a comma, ensuring that they will be easily readable by the Python script.

Step 2: Update the Python Script

The Python script needs to ensure that it accurately captures and formats the serial data. Below is an updated version of your Python script:

[[See Video to Reveal this Text or Code Snippet]]

Explanation of the Python Code

Serial Initialization: Establish a connection with the Arduino using the correct COM port.

Data Reading: The readline method reads each line of the input from the Arduino, which is then decoded and stripped of extra spaces.

Data Splitting: The split(',') method separates the two sensor values into a list for easy handling.

Data Conversion: A list comprehension is used to convert the string sensor values into integers.

Time Capture: The script captures the current time for each data entry.

CSV Writing: Finally, the script opens (or appends) to the CSV file and writes the timestamp along with the two sensor values.

Conclusion

By following these steps, you can effectively read and record data from multiple Arduino ADCs in a format that is both clean and suitable for further analysis in Excel. This approach not only improves your understanding of working with serial data but also sets a solid foundation for future projects involving sensors and data collection.

Feel free to reach out if you have questions or need further clarification on any of the steps!