Easy Way to Create CSV Files with Arduino Uno & Python (Save Data)

[@LearnRobotics]

Interested in getting a Career in Robotics? Join my robotics career coaching program: join.learnrobotics.org/start/?

[@sumitsingh-fm2nz]

I was searching for 4 hours how to save data from arduino to csv and now I got it... Thank you :)

[@jrcuosbn]

This was exactly what I was looking for. Awesome!!!!

[@MartinWeiss1255]

You made my engineering project work!! Thank you for this video!!

[@LearnRobotics]

You are welcome!

[@deldridg]

Thank you Liz for your well produced tutorial - lovely presentation style too. I'm returning to electronics after being a hobbyist as a kid - now doing fun stuff with my son. We're building a wearable Arduino heart rate sensor (possibly also with GPS and 3D accelorometer - MPU-6050 etc.) with logging to an SD card for a school science fair project. We'll be testing his heart rate response to various types of physical exertion and analysing and presenting the findings. You've just saved me a ton of mucking around! Cheers and thank you from Sydney, Aust - Dave and young Will

[@LearnRobotics]

Love our friends in Sydney! Beautiful city. Glad this tutorial helped. Please keep us posted on how your project turned out. We're always impressed with the projects our students make!

[@deldridg]

@@LearnRobotics Hey there! Thanks for your reply. If you are interested, here's a link to my son's video on his Arduino project. He's 10. kzbin.info/www/bejne/ooXLfamDgZuIoKc Hope you enjoy it - your video really helped us and he got a stunned response from his school - they were amazed. Many thanks, Dave

[@5coffeebreak2]

many thanks, thanks a lot ... ... not enough to appreciate your effort and your useful information, please keep going and waiting for more tutorials like this

[@LearnRobotics]

Appreciate the kind words! check out our blog: www.learnrobotics.org/blog/?

[@tildebengtsson865]

Huge thank you, this will help me a lot with my Master Thesis!

[@LearnRobotics]

Let us know how it goes!

[@henka4065]

Now this is what i wanted to see.

[@gustavarium]

I just made a great project with your help! Thank you!

[@LearnRobotics]

Great job!

[@tomoguitaro]

You are a goddess, I have been trying to bring Arduino data into excel for years and it just never really worked out but your video is straight forward and informative, thank you!

[@jonathaniskandar8817]

Thank you Liz for your well content to produced, 🙏

[@Kamal_Kalyan887]

Wonderful you are. Please do make more of these kind 😊🙏🏻 thank you so much

[@RaphaCruz]

Hey Liz, thanks for the tutorial. The procedure to purchase the code is not working.

[@LearnRobotics]

You're welcome! I fixed the link for you. As a thank you, use the code LIZYT to save $10: learnrobotics.ck.page/products/arduino-data-logger?promo=LIZYT

[@jlearnicap911]

Thank you, clear & applied for 100%

[@LearnRobotics]

Excellent!

[@standarde878]

Thanks for the video! I was wondering how to take my Arduino and code for a DAC. I know some boards had a built in DAC and some don't. I'm not sure about mine, I have an Uno that came with the beginners kit. Could you point me in a direction here? I need to take a PWM input and convert it to analog out. I can't use a low pass filter because the output needs to be clean and quick to settle. So I figured a DAC would be best.

[@LearnRobotics]

Sure! You can use an external DAC module like the MCP4725 with your Arduino Uno, which connects via I2C and is easy to control using libraries like the Adafruit MCP4725 library. This will give you a clean and quick analog output without needing a low pass filter.

[@standarde878]

@@LearnRobotics do you know what the frequency range is on the mcp4725? Also, being new to these type of circuits I'm not sure, but I am controlling analog output with PWM input, Not frequency, correct?

[@grimmwits]

Doing this on Windows, arduinoserial module works just fine, up until I attempt to execute the code, and I am met with this error: ModuleNotFoundError: No module named 'termios' I looked it up, and apparently the termios module is unique to Linux from what I've read, and I guess some variant exists on macOS. Is there any fix for this on Windows, or will I have to use an emulator to run this code?

[@josephdaquila2479]

So you could have this running as a logging program and some other code deployed to the firmware of the arduino, right?

[@LearnRobotics]

Yes

[@josephdaquila2479]

@@LearnRobotics thank you learn robotics!

[@stifenjans4342]

data log thumbnail is interesting😄

[@JaviBt4]

Crystal clear! Thank you

[@LearnRobotics]

You're welcome!

[@chamikamac]

this video is great 👍👍

[@LearnRobotics]

Thanks! 😃

[@DIYRobotGirl]

Can we put data angles in serial port from mg996 servos then put the servo angles in excel and then run those angles automated back to arduino. If so can it be done in state machine with millis timer and record wait times? This is with desire to run to arms and kneck 2 axis joint of a humanoid robot in recorded kinematics from pentiometers.

[@LearnRobotics]

Yes - I have an example of this using Raspberry Pi on my blog: www.learnrobotics.org/blog/raspberry-pi-servo-motor/

[@boubacarsantara8085]

I did it Glade ! Thank you!

[@davebrown5850]

Why would I be getting an attribute error for ser=serial.Serial(port="/dev/ttyAMC0") module 'serial' has not attribute 'Serial' ??

[@nupurpurohit6841]

can u pls provide ur code? It's showing an error :: serial.Serial() is not a valid attribute

[@SeetharamN]

Hey Nupur, make sure you have the line. Import serial In the python file. Its a library. Hope this helps

[@waleedaiad3411]

How can i use hc-12 with arduino using python language?.

[@davebrown5850]

Why would I be getting an attribute error for ser=serial.Serial(port="/dev/ttyAMC0") module 'serial' has not attribute 'Serial' ??

[@halifimuhamad]

try to install pyserial package. run cmd pip3 install pyserial

[@jiafu6784]

Is this possible for logging data from different serial ports simultaneously?

[@LearnRobotics]

Possibly, if you're using Python and define different Serial ports. In the Arduino IDE, nope. Usually only lets you use one port at a time

[@geoffwade8144]

Well done, thank you.

[@AbhaySingh-fv7or]

you are glamorous.

[@ashutoshdash7860]

Can you please help to add the time stamp corresponding to each sensor reading while storing in CSV file in python.

[@LearnRobotics]

Read the comments on our blog for the answer to this: www.learnrobotics.org/blog/arduino-data-logger-csv/

[@henishviradiya1468]

Thanks for this, But in second time can we remove the Label of potentiometer and other stuff??

[@LearnRobotics]

Yes you can

[@cryptorcrypt1142]

not sure if you still comment here but i don't get the second row, I only get a \ at the end. Any solutions?

[@LearnRobotics]

Could be a number of things including thresholds (readings not having enough variability), data collection (didn't collect enough samples), or number of samples (set in python file) for example. You'll have to do some debugging to figure out what exactly it is. If it works in Arduino via Serial Monitor, then it's probably something wrong with your Python file writing to a CSV (using the Serial library).

[@Taran72]

WOW! great tutorial: I wouldn't imagine it was so simple. Thank you for explaining everything step by step! My question is: can we view the data in Python and save it to csv at the same time? I will check your channel for more tutorials you may have already answered my question....

[@LearnRobotics]

Yes, you can. Just add print statements in the Python file and the data will show up in the terminal when you run the script

[@Taran72]

@@LearnRobotics , thanks!

[@rafaelrosenberg5214]

awesome! great video! thanks!

[@juneshgautam8655]

You collected only 10 samples, what should I do to gather data every 10 seconds, or any given duration?

[@LearnRobotics]

Use a 10-second delay in loop.

[@juneshgautam8655]

@@LearnRobotics NO, I want to keep on adding data on some files. Like every 10 seconds, I would like to record that Arduino data on some file.

[@LearnRobotics]

@@juneshgautam8655 Same comment as before. You'd have to try and test it out. Unfortunately, I don't debug custom projects in the comment section of my videos. You can visit learnrobotics.org/consult and request a consult if you need personalized help.

[@mohammedsiddig7975]

it is really helpful thanks ever

[@garvasrani8410]

Hi can you please update the code link. Its is not available anymore. Thanks!

[@LearnRobotics]

go to my blog for the most up-to-date links: www.learnrobotics.org/blog/arduino-data-logger-csv/

[@Mohamm-ed]

Thanks very much for wonderful tutorial. Can I upload the csv to any iot cloud? I want to make data logger to store the data from a sensor every 15 seconds in sd card and then send the data for a whole day to iot cloud like thingspeak or something else. I need this very much

[@LearnRobotics]

Yes, you can

[@Mohamm-ed]

@@LearnRobotics how?

[@LearnRobotics]

@@Mohamm-ed Try these two articles on our blog: www.learnrobotics.org/blog/how-to-fetch-data-from-dweet.io-using-python-tutorial/ + www.learnrobotics.org/blog/create-a-database-for-iot-using-dweet-io-tutorial/

[@shahnaman6834]

How we can do this wireless

[@LearnRobotics]

Use a wireless controller or BT dongle instead of USB

[@aakashdewangan7313]

do you use MATLAB/Simulink with Arduino?. It will be great if you make it for control system designing. Let me know if you are planning to do so, recently.

[@LearnRobotics]

Nope - why do you need MATLAB? Is there a particular mathematical module you need from a sensor? You can get basic visualization from the Arduino IDE itself - or just read things serially into Python!

[@tecclaudioperez]

The font in your screen is too small, next time make it bigger please, for blind people like me. Thanks.

[@rverm1000]

excellent!

[@rverm1000]

ive been studing/learning python for 2 years now. it makes it easier to write arduino programs. im going make a mux multimeter and display it with python.

[@dany241]

Thank you

[@manfredbogner9799]

Sehr gut

[@Avissarin]

You can tell this was done by a woman. The wires are all nice and twisted together, men don't do that, we throw it together then complain that the wire keeps falling out.

[@LearnRobotics]

lol spot on

[@rverm1000]

my data log is coming up a little different. b`511,576 \

[@cryptorcrypt1142]

im getting the same, did you find a solution to this?

[@rverm1000]

@@cryptorcrypt1142 ive done a thousand things since then. have no idea

[@cryptorcrypt1142]

@@rverm1000 i figuered it out

[@mohammedsiddig7975]

the song i wounder the name but i founf it

[@engrtehniyat1162]

please give coding in discription box

[@LearnRobotics]

There's a link to the full tutorial on our blog and you can find the source files there.

[@josephocampo]

Nice

[@gustavodearaujo8108]

THANKSSSSSS