ะขั‘ะผะฝั‹ะน

Excel Data To Animated 3D Line Graph Using Blender | Easy Graph Animation Tutorial & Python Script 

5 Minutes Blender
ะŸะพะดะฟะธัะฐั‚ัŒัั 51 ั‚ั‹ั.
ะŸั€ะพัะผะพั‚ั€ะพะฒ 20 ั‚ั‹ั.
50% 1

In this Blender tutorial, we have discussed how to convert some excel data into a 3D line graph with animation. We will use a script for this operation - in fact two. The scripts are given below, just scroll down. Please watch the video for the complete tutorial. If you have any question on this tutorial, please leave your comment below.
๐–๐š๐ญ๐œ๐ก ๐จ๐ฎ๐ซ ๐ƒ๐š๐ญ๐š ๐‚๐จ๐ฆ๐ฉ๐š๐ซ๐ข๐ฌ๐จ๐ง ๐€๐๐-๐จ๐ง ๐Ÿ‘‰ โ€ข Create Excel to Data C...
๐‰๐จ๐ข๐ง ๐จ๐ฎ๐ซ ๐œ๐ก๐š๐ง๐ง๐ž๐ฅ ๐Ÿ๐จ๐ซ ๐ญ๐ก๐ž ๐›๐ฅ๐ž๐ง๐ ๐Ÿ๐ข๐ฅ๐ž & ๐š๐๐๐ข๐ญ๐ข๐จ๐ง๐š๐ฅ ๐ฉ๐ž๐ซ๐ค๐ฌ ๐Ÿ‘‰ / 5minutesblender
๐…๐จ๐ฅ๐ฅ๐จ๐ฐ ๐ฎ๐ฌ ๐จ๐ง ๐ˆ๐ง๐ฌ๐ญ๐š๐ ๐ซ๐š๐ฆ ๐Ÿ‘‰ / 5minutesblender
๐“๐ก๐š๐ง๐ค๐ฌ ๐Ÿ๐จ๐ซ ๐ฒ๐จ๐ฎ๐ซ ๐๐จ๐ง๐š๐ญ๐ข๐จ๐ง๐ฌ ๐Ÿ‘‰ donorbox.org/5-minutes-blender
==================================================
๐…๐ข๐ซ๐ฌ๐ญ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ: ๐“๐ก๐ข๐ฌ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ ๐ž๐ง๐š๐›๐ฅ๐ž๐ฌ ๐๐ฅ๐ž๐ง๐๐ž๐ซ ๐ญ๐จ ๐ซ๐ž๐š๐ ๐Ÿ๐ซ๐จ๐ฆ ๐ž๐ฑ๐œ๐ž๐ฅ ๐Ÿ๐ข๐ฅ๐ž๐ฌ.
๐˜๐จ๐ฎ ๐ง๐ž๐ž๐ ๐ญ๐จ ๐ซ๐ฎ๐ง ๐ข๐ญ ๐จ๐ง๐ฅ๐ฒ ๐จ๐ง๐œ๐ž ๐Ÿ๐จ๐ซ ๐ฒ๐จ๐ฎ๐ซ ๐ฆ๐š๐œ๐ก๐ข๐ง๐ž ๐Ÿ‘‡๐Ÿ‘‡
๐ƒ๐จ๐ฐ๐ง๐ฅ๐จ๐š๐ ๐ญ๐ก๐ž ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ ๐Ÿ๐ซ๐จ๐ฆ ๐ก๐ž๐ซ๐ž ๐Ÿ‘‰ bit.ly/5mbexcel2blender
๐–๐ก๐ž๐ง ๐ฒ๐จ๐ฎ ๐ ๐ž๐ญ ๐š๐ง ๐ž๐ซ๐ซ๐จ๐ซ: If the first script does not run correctly, you'll get an error in the second script (like "Module Not Found" error). The most common source of error is insufficient access on your device, so it is advisable to execute this script from an admin account on your machine. If the error still persists, I suggest you to use the portable version of Blender (follow the steps given here ๐Ÿ‘‰ bit.ly/5mbexcelscripterror) This always works. Or you can skip this and directly go to the 3rd script given below that uses a CSV file instead of Excel.
๐’๐ž๐œ๐จ๐ง๐ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ: ๐“๐ก๐ข๐ฌ ๐ข๐ฌ ๐ญ๐ก๐ž ๐š๐œ๐ญ๐ฎ๐š๐ฅ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ ๐ญ๐จ ๐œ๐ซ๐ž๐š๐ญ๐ž ๐ญ๐ก๐ž ๐š๐ง๐ข๐ฆ๐š๐ญ๐ข๐จ๐ง.
๐˜๐จ๐ฎ ๐ง๐ž๐ž๐ ๐ญ๐จ ๐ซ๐ฎ๐ง ๐ข๐ญ ๐จ๐ง๐œ๐ž ๐Ÿ๐จ๐ซ ๐ž๐š๐œ๐ก ๐ž๐ฑ๐œ๐ž๐ฅ ๐Ÿ๐ข๐ฅ๐ž ๐Ÿ‘‡๐Ÿ‘‡
๐ƒ๐จ๐ฐ๐ง๐ฅ๐จ๐š๐ ๐ญ๐ก๐ž ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ ๐Ÿ๐ซ๐จ๐ฆ ๐ก๐ž๐ซ๐ž (๐๐ฅ๐ž๐ง๐๐ž๐ซ ๐Ÿ‘.๐Ÿ“, ๐Ÿ‘.๐Ÿ”, ๐Ÿ’.๐ŸŽ & ๐ก๐ข๐ ๐ก๐ž๐ซ) ๐Ÿ‘‰ bit.ly/5mb3DxlsGraph
Download the script from here (Blender 3.4 & below) ๐Ÿ‘‰ bit.ly/5mb3DgraphOldxls
๐“๐ก๐ข๐ซ๐ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ: ๐˜๐จ๐ฎ ๐œ๐š๐ง ๐š๐ฅ๐ฌ๐จ ๐ฌ๐š๐ฏ๐ž ๐ฒ๐จ๐ฎ๐ซ ๐„๐ฑ๐œ๐ž๐ฅ ๐Ÿ๐ข๐ฅ๐ž ๐š๐ฌ ๐š ๐‚๐’๐• ๐Ÿ๐ข๐ฅ๐ž ๐š๐ง๐ ๐ฎ๐ฌ๐ž ๐ญ๐ก๐ž ๐Ÿ๐จ๐ฅ๐ฅ๐จ๐ฐ๐ข๐ง๐  ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ ๐ญ๐จ ๐œ๐ซ๐ž๐š๐ญ๐ž ๐š ๐Ÿ‘๐ƒ ๐ ๐ซ๐š๐ฉ๐ก ๐Ÿ๐ซ๐จ๐ฆ ๐ญ๐ก๐š๐ญ ๐‚๐’๐• ๐Ÿ๐ข๐ฅ๐ž. This is recommended if you are getting an error while running the above script. In this script, you need to mention the CSV file path instead of Excel, and all other things remain the same.
๐˜๐จ๐ฎ ๐ง๐ž๐ž๐ ๐ญ๐จ ๐ซ๐ฎ๐ง ๐ข๐ญ ๐จ๐ง๐œ๐ž ๐Ÿ๐จ๐ซ ๐ž๐š๐œ๐ก ๐‚๐’๐• ๐Ÿ๐ข๐ฅ๐ž ๐Ÿ‘‡๐Ÿ‘‡
๐ƒ๐จ๐ฐ๐ง๐ฅ๐จ๐š๐ ๐ญ๐ก๐ž ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ ๐Ÿ๐ซ๐จ๐ฆ ๐ก๐ž๐ซ๐ž (๐๐ฅ๐ž๐ง๐๐ž๐ซ ๐Ÿ‘.๐Ÿ“, ๐Ÿ‘.๐Ÿ”, ๐Ÿ’.๐ŸŽ & ๐ก๐ข๐ ๐ก๐ž๐ซ) ๐Ÿ‘‰ bit.ly/5mb3DcsvGraph
Download the script from here (Blender 3.4 & below) ๐Ÿ‘‰ bit.ly/5mb3DgraphOldcsv
==================================================
We have many more tutorials that can help you learn Blender like a professional. You can go through the following playlists for the relevant topics:
๐Ÿ‘‡ ๐๐ฅ๐ž๐ง๐๐ž๐ซ ๐…๐จ๐ฎ๐ง๐๐š๐ญ๐ข๐จ๐ง ๐‚๐จ๐ฎ๐ซ๐ฌ๐ž ๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ:
If you are absolutely new to Blender, take this foundation course.
โ€ข Blender Foundation Course
๐Ÿ‘‡ ๐€๐ฅ๐ฅ ๐Ÿ๐Ÿ ๐‚๐ฅ๐š๐ฌ๐ฌ๐ž๐ฌ ๐“๐จ๐ ๐ž๐ญ๐ก๐ž๐ซ ๐ˆ๐ง ๐Ž๐ง๐ž ๐‡๐จ๐ฎ๐ซ:
โ€ข Blender Foundation Cou...
๐Ÿ‘‡ ๐๐ฅ๐ž๐ง๐๐ž๐ซ ๐“๐ข๐ฉ๐ฌ ๐€๐ง๐ ๐“๐ซ๐ข๐œ๐ค๐ฌ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ):
โ€ข Blender Tips & Tricks
๐Ÿ‘‡ ๐„๐š๐ฌ๐ฒ ๐Œ๐จ๐๐ž๐ฅ๐ฌ ๐…๐จ๐ซ ๐๐ž๐ ๐ข๐ง๐ง๐ž๐ซ๐ฌ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ):
โ€ข Easy Models For Beginners
๐Ÿ‘‡ ๐Œ๐š๐ญ๐ž๐ซ๐ข๐š๐ฅ๐ฌ ๐˜๐จ๐ฎ ๐๐ž๐ž๐ ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ):
โ€ข Materials You Need In ...
๐Ÿ‘‡ ๐€๐ฅ๐ฅ ๐“๐ž๐ฑ๐ญ ๐„๐Ÿ๐Ÿ๐ž๐œ๐ญ๐ฌ ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ):
โ€ข Text Effects In Blender
๐Ÿ‘‡ ๐‚๐š๐ฆ๐ž๐ซ๐š ๐Œ๐จ๐ฏ๐ž๐ฆ๐ž๐ง๐ญ & ๐’๐ž๐ญ๐ญ๐ข๐ง๐ ๐ฌ ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ:
โ€ข Camera Movement & Sett...
๐Ÿ‘‡ ๐”๐ฌ๐ž๐Ÿ๐ฎ๐ฅ ๐‹๐ข๐ ๐ก๐ญ๐ข๐ง๐  ๐’๐ž๐ญ๐ฎ๐ฉ ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ):
โ€ข Useful Lighting Setup ...
๐Ÿ‘‡ ๐‘๐ข๐ ๐ข๐ ๐๐จ๐๐ฒ ๐๐ก๐ฒ๐ฌ๐ข๐œ๐ฌ & ๐‘๐ข๐ ๐ข๐ ๐๐จ๐๐ฒ ๐‚๐จ๐ง๐ฌ๐ญ๐ซ๐š๐ข๐ง๐ญ๐ฌ:
โ€ข Rigid Body Physics in ...
๐Ÿ‘‡ ๐…๐ข๐ซ๐ž & ๐’๐ฆ๐จ๐ค๐ž ๐’๐ข๐ฆ๐ฎ๐ฅ๐š๐ญ๐ข๐จ๐ง ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ):
โ€ข Fire & Smoke Simulatio...
๐Ÿ‘‡ ๐…๐ฅ๐ฎ๐ข๐ ๐’๐ข๐ฆ๐ฎ๐ฅ๐š๐ญ๐ข๐จ๐ง ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ):
โ€ข Fluid Simulation in Bl...
๐Ÿ‘‡ ๐Œ๐š๐ฌ๐ญ๐ž๐ซ๐ข๐ง๐  ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ):
โ€ข Mastering Blender
If you want to watch our own creations in Blender, you can also check out the following channel where we regularly upload videos on Animation, Space Exploration and AI.
๐Ž๐ฎ๐ซ ๐จ๐ญ๐ก๐ž๐ซ ๐œ๐ก๐š๐ง๐ง๐ž๐ฅ ๐ฅ๐ข๐ง๐ค: / @thealienworld
#Blender #Animation #Tutorial #Excel
Timestamp
00:00 Create a link between Blender & Excel
00:56 Convert an excel file into 3D animation
02:32 Further enhancements with Python

ะžะฟัƒะฑะปะธะบะพะฒะฐะฝะพ:

 

29 ะธัŽะฝ 2024

ะŸะพะดะตะปะธั‚ัŒัั:

ะกัั‹ะปะบะฐ:

ะกะบะฐั‡ะฐั‚ัŒ:

ะ“ะพั‚ะพะฒะธะผ ััั‹ะปะบัƒ...

ะ”ะพะฑะฐะฒะธั‚ัŒ ะฒ:

ะœะพะน ะฟะปะตะนะปะธัั‚
ะŸะพัะผะพั‚ั€ะตั‚ัŒ ะฟะพะทะถะต
ะšะพะผะผะตะฝั‚ะฐั€ะธะธ : 103   
@5MinutesBlender
@5MinutesBlender 11 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
๐…๐จ๐ซ๐ ๐ž๐ญ ๐š๐›๐จ๐ฎ๐ญ ๐ญ๐ก๐ž๐ฌ๐ž ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ๐ฌ ๐š๐ง๐ ๐ฎ๐ฌ๐ž ๐จ๐ฎ๐ซ ๐ƒ๐š๐ญ๐š ๐‚๐จ๐ฆ๐ฉ๐š๐ซ๐ข๐ฌ๐จ๐ง ๐€๐๐-๐จ๐ง, it's more powerful, more flexible and easy to apply - ๐‡๐ž๐ซ๐ž ๐ข๐ฌ ๐ญ๐ก๐ž ๐ญ๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ ๐Ÿ‘‰ ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GILuvtHsMNY.html Get it from ๐Ÿ‘‰ 5minblender.gumroad.com/l/3d-data-visualizer or www.blendermarket.com/products/3d-data-visualizer
@sudarshana8606
@sudarshana8606 ะ“ะพะด ะฝะฐะทะฐะด
I am waiting for your videos always
@SourceAwareness
@SourceAwareness ะ“ะพะด ะฝะฐะทะฐะด
This is Excellent, thanks so much, my Good Friend!! I've been looking for something like this.
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
I'm happy to know that it helped you ๐Ÿ˜Š๐Ÿ’๐Ÿ’
@mohamedabdo-xg6tw
@mohamedabdo-xg6tw 8 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
I just received my member contents. let's Goooo !
@5MinutesBlender
@5MinutesBlender 8 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
Awesome! All the best ๐Ÿ‘๐Ÿ‘
@karammohammed5044
@karammohammed5044 ะ“ะพะด ะฝะฐะทะฐะด
beautifully done
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Thank you so much ๐Ÿ˜Š Glad you liked it ๐Ÿ’
@sebbosebbo9794
@sebbosebbo9794 ะ“ะพะด ะฝะฐะทะฐะด
uhhh....ahhhh.......nice....... p.s. Text option for data points and other visual style type or shapes....cool idea..
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Glad you liked it ๐Ÿ˜Š
@SS.2026
@SS.2026 7 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
The pip install step can be skipped by including the path to your pandas or whatever system python module by doing something like import sys; sys.path.append('/usr/lib/python3/dist-packages/'); import pandas as p at the top of your csv script The way to find the path to include, is open your python console (not the blender python but system python) import whatevermodule; print(whatevermodule.__path__) And thanks for the great video! Was very useful in understanding how to integrate csv files and blender ๐Ÿ™
@5MinutesBlender
@5MinutesBlender 7 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
Thanks for the tips ๐Ÿ‘ The method you have described is system-specific, right? I mean the pandas package has to be first installed in the system beforehand, and then the installation path may be also different for different machines ๐Ÿค”๐Ÿค”
@NnamdiNw
@NnamdiNw 5 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
@@5MinutesBlenderYh if you already have it installed in another environment then you do it through the sys.insert command
@5MinutesBlender
@5MinutesBlender 5 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
@@NnamdiNw Yep, thanks for the alternate suggestion ๐Ÿ‘
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
๐ˆ๐Ÿ ๐ฒ๐จ๐ฎ ๐š๐ซ๐ž ๐ ๐ž๐ญ๐ญ๐ข๐ง๐  ๐š๐ง ๐ž๐ซ๐ซ๐จ๐ซ ๐ฐ๐ก๐ข๐ฅ๐ž ๐ซ๐ฎ๐ง๐ง๐ข๐ง๐  ๐ญ๐ก๐ž ๐Ÿ๐ง๐ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ, it is often due to access restrictions. You can use the Portable version of Blender (steps are given here ๐Ÿ‘‰ bit.ly/5mbexcelscripterror) or use the CSV version of our script (the 3rd script given in the video description). You can always reach us at 5minblender@gmail.com if you are still getting any issues.
@skillmaxacademy
@skillmaxacademy ะ“ะพะด ะฝะฐะทะฐะด
Thank you please do construction animation using animation nodes
@pufoamtoolsandguides
@pufoamtoolsandguides ะ“ะพะด ะฝะฐะทะฐะด
with blender version 3.5 it just copy paste and run. good job
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Glad you found it useful! ๐Ÿ˜Š๐Ÿ’๐Ÿ’
@ex-secular-4996
@ex-secular-4996 ะ“ะพะด ะฝะฐะทะฐะด
Beautiful work brother
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Thank you so much ๐Ÿ’๐Ÿ’
@ex-secular-4996
@ex-secular-4996 ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender ๐Ÿ‘
@kabre_ali
@kabre_ali ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender Can you make a video on how to create a background city for data comparison videos??
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
โ€‹@@kabre_ali If you want to do it quickly, you can use a realistic high resolution picture and place it in the background. The angle of the picture should be perfect otherwise it won't go with the video. But this is really not a good technique. Creating an actual real city would take a lot of time. The things are not so difficult, you create several different buildings and use array modifiers to duplicate them several times to populate the city. It can take a week to create it but the end result will be satisfying. We will see if we can come up with a tutorial on this.
@kabre_ali
@kabre_ali ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender Okay, I have tried too many times but I wasn't able to do it. It will be great if you do it. Thank you so much for your answer. I'm always enjoying your contents!!
@PythonHarry
@PythonHarry 3 ะผะตััั†ะฐ ะฝะฐะทะฐะด
i love this
@5MinutesBlender
@5MinutesBlender 3 ะผะตััั†ะฐ ะฝะฐะทะฐะด
Thank you so much ๐Ÿ’๐Ÿ’ We have an add-on for this, you may be interested ๐Ÿ˜Š
@sportsfamily01
@sportsfamily01 ะ“ะพะด ะฝะฐะทะฐะด
Gravity video making tutorial please
@mayssayasmina2072
@mayssayasmina2072 ะœะตััั† ะฝะฐะทะฐะด
H great method, can we export this animation to gltf or glb ? thank you
@5MinutesBlender
@5MinutesBlender ะœะตััั† ะฝะฐะทะฐะด
No, I am afraid that it may not be possible to export the animation part, but you can export the static graph (last frame).
@kebabsharif9627
@kebabsharif9627 ะ“ะพะด ะฝะฐะทะฐะด
THANK YOU FOR YOUR VIDEO, I USED YOUR CODE THEN I NOTICED THAT THE YELLOW CURVE SAW NOT SHOWING IS IT CORRECT OR I MISSED SOMETHING? THANK YOU IN ADVANCE.
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
The output is animated. So if you are at the start of the animation, nothing will be visible. If you play the animation, the curve will progress and get visible. To quickly check it you can go to the last frame and verify if the curve is visible. Please let me know what you see.
@muhamedsewidan3704
@muhamedsewidan3704 ะ“ะพะด ะฝะฐะทะฐะด
Great video, thank you. But I have a problem running the code because I have all the required packages on my python, but blender can't read it and when I try to install these packages in blender it says the requirements are already satisfied. Can you help me?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
It is a common problem. Often due to insufficient access, it will install the packages into user's area instead of blender library. Please check the error scenario and the solution mentioned in that document (attached the link in the video description). We need to give the instruction where to install the packages exactly (otherwise Blender can't see it). However, it also needs sufficient access privileges, otherwise it can still fail. Whatever happens, the system console will tell you. It even highlights the error msgs like access denied etc. In a nutshell, we need the pandas and openpyxl installed inside Blender's python library folder. Otherwise the script won't work.
@selumi
@selumi 11 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
Thank you. I tried this code and it was just I needed for graph animation. One question if it's okay to ask: my data has decimal numbers and negative numbers. The graph showed a long decimal numbers when I tried to run the code. for example, 0.5165 becomes 0.51650000000 on the graph. Is there anyway to fix the code?
@5MinutesBlender
@5MinutesBlender 11 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
Hi, we have to work on the negative numbers, it is not yet done. But the other problem that you have mentioned (long decimals) is easy to fix. In the script, you'll find an expression str(data_list[data_counter]) Search for it. You have to just replace this with str(data_list[data_counter]).split(".")[0] + "." + str(data_list[data_counter]).split(".")[1][:2] (put everything on the same line, don't break it on multiple lines). This assumes you have a decimal point for each number. If some numbers have a decimal point and some don't, it will need few more lines of code. You can send me a mail at 5minblender@gmail.com if required, I will be happy to assist you on this. Thank you!
@selumi
@selumi 11 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
@@5MinutesBlender thank you very much! it helped a lot. I can see why this one needs to be fixed thanks to the code. I didn't know which code had to be fixed until I see your answer. Thank you!
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
๐–๐š๐ญ๐œ๐ก ๐ก๐จ๐ฐ ๐ญ๐จ ๐ฎ๐ฌ๐ž ๐๐ฅ๐ž๐ง๐๐ž๐ซ ๐ญ๐จ ๐œ๐ซ๐ž๐š๐ญ๐ž ๐–๐จ๐ซ๐ฅ๐ ๐ƒ๐š๐ญ๐š ๐‚๐จ๐ฆ๐ฉ๐š๐ซ๐ข๐ฌ๐จ๐ง ๐ฏ๐ข๐๐ž๐จ๐ฌ ๐Ÿ๐ซ๐จ๐ฆ ๐ฒ๐จ๐ฎ๐ซ ๐ž๐ฑ๐œ๐ž๐ฅ ๐Ÿ๐ข๐ฅ๐ž ๐Ÿ‘‰ ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zyNB3gZagXQ.html
@dustonclubs3867
@dustonclubs3867 ะ“ะพะด ะฝะฐะทะฐะด
I want to change month column to a integer value? In code where I need to change?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Just change line 356 to: *ob.data.body = str(text_month)*
@pigcheong3283
@pigcheong3283 ะ“ะพะด ะฝะฐะทะฐะด
in the file path: what is "r" stand for, (I am using mac os),....thank you
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Good question! "r" stands for raw, it means Blender (i.e. python) should not modify the path in any way. Usually it tends to add the current directory or the system path or replace backslashes with corresponding escape characters. Raw means the program will use the path as-is.
@dustonclubs3867
@dustonclubs3867 ะ“ะพะด ะฝะฐะทะฐะด
Make a tutorial on this how to make 2 graph lines
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
It's actually very similar to the single-line graph. We just need to repeat some part of the script with the second set of data. We have shared it with the members of this channel (the script for 2 graph lines), they have access to it. A separate tutorial is probably not needed, since it is the same thing only with some changes in the script.
@kylebeschler03
@kylebeschler03 ะ“ะพะด ะฝะฐะทะฐะด
For the pdf displaying the errors, where would I place the two pieces of code at? This is where I got stumped cuz I do have some experience with python but not a ton.
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Hi, in our first script, you'll see similar two lines of code. Replace them with what is given in the suggestion. Then run the first script. Unless this first script runs successfully, the second script will fail. Please let me know the outcome. Thanks!
@kylebeschler03
@kylebeschler03 ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender Do I need an excel directory for the code to work?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
@@kylebeschler03 No, you do not need excel directory. You do not even need excel to be installed on your machine. Just keep the excel file in some place and mention that location correctly in the beginning of the script as shown in the tutorial. If you get any error, do let me know or send us the error screenshot from the system console.
@kylebeschler03
@kylebeschler03 ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender does it work with google sheets as well? Cuz I have that but I dont have a file that has numerical data.
@sportsplusph
@sportsplusph ะ“ะพะด ะฝะฐะทะฐะด
Maybe you can help me sir, error appears even if i change the first script based on the installation folder...
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
What is the error and in which script are you getting this error? Please toggle the system console window, copy the error description from there and send to 5minblender@gmail.com I will get back to you with possible fixes.
@InOppositiontotheNewWorldOrder
@InOppositiontotheNewWorldOrder 8 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
Do you have a script for LibreOffice Writer?
@5MinutesBlender
@5MinutesBlender 8 ะผะตััั†ะตะฒ ะฝะฐะทะฐะด
Yes. All our scripts have two versions: Excel and CSV. Almost all spreadsheet writers including LibreOffice supports CSV format. You can save your spreadsheet in LibreOffice as a CSV file and use that with our script. In fact it is much easier to run the script with CSV file than Excel because the later needs some additional modules to be installed first.
@Noble_Thoughts_Views
@Noble_Thoughts_Views ะ“ะพะด ะฝะฐะทะฐะด
Will it work for LibreOffice Calc?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
It can be done. This script can be slightly modified to work with csv file instead of excel. Now in LibreOffice we need to export the data in a csv file, then you can use this script to create the 3d curve.
@Noble_Thoughts_Views
@Noble_Thoughts_Views ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender Ok. I will try and let you know. Thank you very much for swift response.
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
@@Noble_Thoughts_Views Or you can convert the csv file into an excel using free converters available online, or using MS Office online version. Should be an easy task.
@cognizantcomparisons
@cognizantcomparisons ะ“ะพะด ะฝะฐะทะฐะด
Hey I sent a mail about an issue! There is no line drawn for me. The dots pop up bet there is no line between them. Do you know how to fix this issue?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Hi, which version of Blender are you using?
@cognizantcomparisons
@cognizantcomparisons ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender I'm using 3.4.1 I think
@cognizantcomparisons
@cognizantcomparisons ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender I also sent a screen shot of it and sent it to your mail if that helps??
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
@@cognizantcomparisons I just replied. Would help if you can send your blend file too.
@alexanderg8466
@alexanderg8466 ะ“ะพะด ะฝะฐะทะฐะด
I don't get it.. I want to input my x value not as a "month" but a number.
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Store your x value in the month column and change the header ("month") to something more meaningful for you. However, this will show your x-values on the graph. If you want to display the x-values along the x-axis, on the x-axis, the script needs to be modified for that specific customization.
@swagprajapat410
@swagprajapat410 ะ“ะพะด ะฝะฐะทะฐะด
Bro , Another way to making graf ?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
I did not get you bro, what did you ask? ๐Ÿค”๐Ÿค”
@preeshanupadhyay146
@preeshanupadhyay146 ะ“ะพะด ะฝะฐะทะฐะด
HOW DO I ADD A LOGO IN THE ANIMATION ?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
You can render the video as an image sequence. Then use Blender's VSE (Video Sequence Editor) to create a video from that image sequence along with a logo picture (you have to add a logo file from Add>Image).
@yangzeng4277
@yangzeng4277 ะ“ะพะด ะฝะฐะทะฐะด
is there another 3.4 blender script links?(the original link is not working now๐Ÿ˜‚)
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Yes, updated the links now in the video description, please check and let us know if any more issues.
@yangzeng4277
@yangzeng4277 ะ“ะพะด ะฝะฐะทะฐะด
thanks a lot๐Ÿ˜€
@dustonclubs3867
@dustonclubs3867 ะ“ะพะด ะฝะฐะทะฐะด
Canโ€™t animate with 4 digit number? Solution plz?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Why, what happened with 4-digit numbers? It seems to work fine with 4 digits at my end ๐Ÿค”
@dustonclubs3867
@dustonclubs3867 ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender when I give example 1988, 2133 values, the graph is moving parallel without up and down
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
@@dustonclubs3867 Understood. This will need a custom change because the difference in the values is small compared to the individual values. The graph is mathematically correct, but it does not look presentable. So a change is needed in the script to artificially amplify the differences and draw the graph based on that while the correct data is displayed alongside the graph.
@dustonclubs3867
@dustonclubs3867 ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender where I need to change script?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
@@dustonclubs3867 In our script, there is a list called normalized_data which we are building from the original excel data and these normalized values are actually used for drawing the graph. The logic to create this data needs suitable changes. It won't be a single line change. If I get time I will see if I can share an updated script for your requirement. In the long run, I have a plan to create an add-on that will work with any range of data with more flexibility.
@pigcheong3283
@pigcheong3283 ะ“ะพะด ะฝะฐะทะฐะด
I got name error message: Name" My Harddrive's name" is not define
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Probably your hard drive is using a different letter than C: ๐Ÿค” Do you have a C: drive?
@pigcheong3283
@pigcheong3283 ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender Thank you for your kind reply: I am using Mac OS 10.15, My harddrive's name is "IronWolfPro"
@manart6506
@manart6506 ะ“ะพะด ะฝะฐะทะฐะด
I use Mac and Numbersโ€ฆ I guess this doesnโ€™t quite work with that?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Blender also runs on Mac, but excel is not there. However, this script can be easily modified to use csv file instead of excel. Then you can use this on your Mac as well.
@manart6506
@manart6506 ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender yeah I would like to try this.
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
@@manart6506 Or you can convert the csv file into an excel using free converters available online, or using MS Office online version. Should be an easy task.
@giorgiobenetti
@giorgiobenetti ะ“ะพะด ะฝะฐะทะฐะด
I'm getting this error: ModuleNotFoundError: no Module names pandas
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Hi, sorry for the late reply. This error in the second script comes when the first script fails to run correctly. Often due to insufficient access privileges on your machine, the first script installs the modules in a different location - not within Blender. It will show a success code but this is of no use. Unless the modules are installed within Blender, the second script will fail and you'll get that error msg. You must have administrative access on your machine and then run the first script. Better still, check our modified script given in the possible error scenarios (in the video description) which will force your system to install the modules in the correct folder. Further to this, you can send the results in a mail to 5minblender@gmail.com and I will try to help you as far as possible in resolving these issues. But root cause of the error is insufficient access on your machine, so please get that access enabled before we do anything.
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
@giorgiobenetti was it resolved? I recently discovered that using the portable version of Blender helps in this case since there is no access problems with the portable version. Please let me know your email ID so that we can help you further on this.
@anandsaga9217
@anandsaga9217 ะ“ะพะด ะฝะฐะทะฐะด
Hello
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Hi, tell me!
@emileravenet
@emileravenet ะ“ะพะด ะฝะฐะทะฐะด
Only works for pc
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
Actually Blender is really designed for pc only. Are you trying to do it on your mobile device?
@emileravenet
@emileravenet ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender blender is Mac and PC! :)
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
@@emileravenet Ah that way! I think if you can get the conversion from excel to csv file done correctly (please note that we are talking about comma separated file, some systems use a different delimiter for csv format), rest of the things should work alike in mac and pc. And that conversion can be done online, without having any software installed on your pc - I mean, mac :)
@emileravenet
@emileravenet ะ“ะพะด ะฝะฐะทะฐะด
@@5MinutesBlender wow interesting, the csv file I used is all seperated with commas... Thanks for troubleshooting with me, earned my sub. unfortunately there's no packaged version for blender for Mac like there is PC
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
@@emileravenet I see. Can you tell me what errors you are getting when you use that comma separated file with our CSV script? Better still, if you can send your CSV file to us (5minblender@gmail.com) we can verify and confirm that it is nothing to do with the file or the script, just a windows vs mac thing or not!
@Sharego.
@Sharego. ะ“ะพะด ะฝะฐะทะฐะด
How many cubes you do delete ๐Ÿ˜‚
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
๐Ÿ˜‚ ๐Ÿคฃ๐Ÿคฃ๐Ÿคฃ
@darklord99104
@darklord99104 ะ“ะพะด ะฝะฐะทะฐะด
hey i think you are an indian ?
@5MinutesBlender
@5MinutesBlender ะ“ะพะด ะฝะฐะทะฐะด
There are others who are asking if I am a human. You are at least one step ahead, I like it ๐Ÿ˜Š๐Ÿ’๐Ÿ’๐Ÿ’
ะ”ะฐะปะตะต
Top 15 Blender Channels | 3D Comparison Video | A Tribute To All Great Minds For Blender Tutorials ๐Ÿ‘
1:05
ะŸั€ะพัะผะพั‚ั€ะพะฒ 8 ั‚ั‹ั.
Data Visualization in Blender and Python
33:51
ะŸั€ะพัะผะพั‚ั€ะพะฒ 69 ั‚ั‹ั.
์น˜ํ† ์Šค๋กœ ์ฒด๊ฐ๋˜๋Š” ์š”์ฆ˜ ๋ฌผ๊ฐ€
00:16
ะŸั€ะพัะผะพั‚ั€ะพะฒ 692 ั‚ั‹ั.
Flipping Pages: Animation In Blender | Easy Step By Step Tutorial | Books | Magazines | Diaries etc.
9:26
ะŸั€ะพัะผะพั‚ั€ะพะฒ 107 ั‚ั‹ั.
Animate Excel Data With Blender | Convert Your Excel File Into 3D Animation Video | World Data Video
3:27
ะŸั€ะพัะผะพั‚ั€ะพะฒ 14 ั‚ั‹ั.
How To Pour Liquid & Fill Objects With Liquid | Fluid Simulation Explained In Blender 4.0
9:50
ะŸั€ะพัะผะพั‚ั€ะพะฒ 6 ั‚ั‹ั.
Godot XR Hand Pose Detector
1:39
ะŸั€ะพัะผะพั‚ั€ะพะฒ 211
How to Bend Objects In Blender | Simple Deform Modifier | All Settings Explained With Examples
7:38
ะŸั€ะพัะผะพั‚ั€ะพะฒ 224 ั‚ั‹ั.
Visualize Real-World CSV/Excel Data in Blender (3D Chart Animation Nodes Tutorial)
27:58
ะŸั€ะพัะผะพั‚ั€ะพะฒ 31 ั‚ั‹ั.
Create Data Comparison Videos From Excel Files | No Manual Work Needed | Setup Camera With PY Script
5:07
ะŸั€ะพัะผะพั‚ั€ะพะฒ 26 ั‚ั‹ั.
5 Steps to setup VSCode for Blender Python (on Windows)
12:29
ะŸั€ะพัะผะพั‚ั€ะพะฒ 21 ั‚ั‹ั.
Making Animations in Python using Matplotlib!
22:05
ะŸั€ะพัะผะพั‚ั€ะพะฒ 7 ั‚ั‹ั.
How to Create 3D Terrain with Google Maps and Blender!
12:17
ะŸั€ะพัะผะพั‚ั€ะพะฒ 1,9 ะผะปะฝ