Back to Browse

Create Data Comparison Videos From Excel Files | No Manual Work Needed | Setup Camera With PY Script

47.0K views
Apr 5, 2023
5:06

In this Blender tutorial, we have discussed how to create a world data comparison video super fast with our Python script. No manual work is needed at all. Just fill-in your data in an excel format and Blender will generate a good-looking data comparison video with appropriate lighting and background. Please watch the video for the complete tutorial. If you have any question on this tutorial, please leave your comment below. ๐ˆ๐Ÿ ๐ฒ๐จ๐ฎ ๐ ๐ž๐ญ ๐š๐ง ๐ž๐ซ๐ซ๐จ๐ซ, ๐ฐ๐š๐ญ๐œ๐ก ๐จ๐ฎ๐ซ ๐ฌ๐ž๐œ๐จ๐ง๐ ๐ฏ๐ข๐๐ž๐จ ๐ก๐ž๐ซ๐ž ๐Ÿ‘‰ https://youtu.be/i3fAtQj-6X0 ๐‚๐ก๐ž๐œ๐ค ๐จ๐ฎ๐ซ ๐Ÿ‘๐ƒ ๐ƒ๐š๐ญ๐š ๐•๐ข๐ฌ๐ฎ๐š๐ฅ๐ข๐ณ๐ž๐ซ ๐š๐๐-๐จ๐ง (๐š ๐›๐ž๐ญ๐ญ๐ž๐ซ ๐จ๐ฉ๐ญ๐ข๐จ๐ง) ๐Ÿ‘‰ https://youtu.be/zlmzTM4Bnus ================================================== ๐ˆ๐ง๐ฌ๐ญ๐ซ๐ฎ๐œ๐ญ๐ข๐จ๐ง๐ฌ ๐จ๐ง ๐ก๐จ๐ฐ ๐ญ๐จ ๐ฎ๐ฌ๐ž ๐จ๐ฎ๐ซ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ: Create a folder called C:\MyTest on your computer (if you use another folder location, you need to change this name in our script). You have to keep 4 things within this folder: One excel file containing your data (use your own or download our sample file from https://bit.ly/5mbSampleExcel), a font file (download from https://bit.ly/5mbarialbdfont), a world HDRI file (download from https://bit.ly/5mbworldHDRI) and a subfolder called Pictures that should contain all your pictures or logo files. Now open Blender and run the following scripts, then render the video from Blender. ๐…๐ข๐ซ๐ฌ๐ญ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ: ๐“๐ก๐ข๐ฌ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ ๐ž๐ง๐š๐›๐ฅ๐ž๐ฌ ๐๐ฅ๐ž๐ง๐๐ž๐ซ ๐ญ๐จ ๐ซ๐ž๐š๐ ๐Ÿ๐ซ๐จ๐ฆ ๐š๐ง ๐ž๐ฑ๐œ๐ž๐ฅ ๐Ÿ๐ข๐ฅ๐ž. ๐˜๐จ๐ฎ ๐ง๐ž๐ž๐ ๐ญ๐จ ๐ซ๐ฎ๐ง ๐ข๐ญ ๐จ๐ง๐ฅ๐ฒ ๐จ๐ง๐œ๐ž ๐Ÿ๐จ๐ซ ๐ฒ๐จ๐ฎ๐ซ ๐ฆ๐š๐œ๐ก๐ข๐ง๐ž ๐Ÿ‘‰ https://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). This is mostly caused by insufficient access issues, so it is advisable to execute this script from an admin account on your machine. If the error still persists, you can skip this step and use the CSV version of our script given below. ๐’๐ž๐œ๐จ๐ง๐ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ (๐„๐ฑ๐œ๐ž๐ฅ ๐•๐ž๐ซ๐ฌ๐ข๐จ๐ง): ๐ˆ๐ญ ๐œ๐ซ๐ž๐š๐ญ๐ž๐ฌ ๐ญ๐ก๐ž ๐ง๐ž๐œ๐ž๐ฌ๐ฌ๐š๐ซ๐ฒ ๐š๐ง๐ข๐ฆ๐š๐ญ๐ข๐จ๐ง ๐š๐ฅ๐จ๐ง๐  ๐ฐ๐ข๐ญ๐ก ๐ญ๐ก๐ž ๐œ๐š๐ฆ๐ž๐ซ๐š ๐ฌ๐ž๐ญ๐ฎ๐ฉ ๐Ÿ‘‰ https://drive.google.com/file/d/19ARAJazZFT2B0yrpU9mLhHiEaHmCk0S-/view?usp=sharing ๐’๐ž๐œ๐จ๐ง๐ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ (๐‚๐’๐• ๐•๐ž๐ซ๐ฌ๐ข๐จ๐ง): ๐’๐š๐ฏ๐ž ๐ฒ๐จ๐ฎ๐ซ ๐„๐ฑ๐œ๐ž๐ฅ ๐Ÿ๐ข๐ฅ๐ž ๐š๐ฌ ๐š ๐‚๐’๐• ๐Ÿ๐ข๐ฅ๐ž ๐š๐ง๐ ๐ฎ๐ฌ๐ž ๐ญ๐ก๐ข๐ฌ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ ๐Ÿ‘‰ https://drive.google.com/file/d/1IB7X-GS6nVb7T515qK3yBlglLI6Atcif/view?usp=sharing This is recommended if you are getting errors in 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. ๐“๐ก๐ข๐ซ๐ ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ (๐„๐ฑ๐œ๐ž๐ฅ & ๐‚๐’๐• ๐•๐ž๐ซ๐ฌ๐ข๐จ๐ง๐ฌ ๐ญ๐จ๐ ๐ž๐ญ๐ก๐ž๐ซ): ๐“๐ก๐ข๐ฌ ๐ข๐ฌ ๐š๐œ๐œ๐ž๐ฌ๐ฌ๐ข๐›๐ฅ๐ž ๐จ๐ง๐ฅ๐ฒ ๐Ÿ๐จ๐ซ ๐จ๐ฎ๐ซ ๐ฆ๐ž๐ฆ๐›๐ž๐ซ๐ฌ. ๐’๐š๐ฏ๐ž ๐ฒ๐จ๐ฎ๐ซ ๐„๐ฑ๐œ๐ž๐ฅ ๐Ÿ๐ข๐ฅ๐ž ๐š๐ฌ ๐š ๐‚๐’๐• ๐Ÿ๐ข๐ฅ๐ž ๐š๐ง๐ ๐ฎ๐ฌ๐ž ๐ญ๐ก๐ž ๐‚๐’๐• ๐ฌ๐œ๐ซ๐ข๐ฉ๐ญ ๐ข๐Ÿ ๐ฒ๐จ๐ฎ ๐š๐ซ๐ž ๐ ๐ž๐ญ๐ญ๐ข๐ง๐  ๐š๐ง ๐ž๐ซ๐ซ๐จ๐ซ ๐ข๐ง ๐ญ๐ก๐ž ๐„๐ฑ๐œ๐ž๐ฅ ๐ฏ๐ž๐ซ๐ฌ๐ข๐จ๐ง. It creates the animation, the camera setup, background and lighting, floor and the world setup, no need to run the second script if you use this ๐Ÿ‘‰ https://drive.google.com/file/d/1Wp6FOGiTaR-gA2fxALTajsmgbOjqm1km/view?usp=sharing ================================================== ๐‰๐จ๐ข๐ง ๐จ๐ฎ๐ซ ๐œ๐ก๐š๐ง๐ง๐ž๐ฅ ๐Ÿ๐จ๐ซ ๐ญ๐ก๐ž ๐›๐ฅ๐ž๐ง๐ ๐Ÿ๐ข๐ฅ๐ž & ๐š๐๐๐ข๐ญ๐ข๐จ๐ง๐š๐ฅ ๐ฉ๐ž๐ซ๐ค๐ฌ ๐Ÿ‘‰ https://www.youtube.com/c/5MinutesBlender/join ๐…๐จ๐ฅ๐ฅ๐จ๐ฐ ๐ฎ๐ฌ ๐จ๐ง ๐ˆ๐ง๐ฌ๐ญ๐š๐ ๐ซ๐š๐ฆ ๐Ÿ‘‰ https://www.instagram.com/5minutesblender/ We have many more tutorials that can help you learn Blender like a professional. You can go through these playlists on each topic: ๐Ÿ‘‡ ๐๐ฅ๐ž๐ง๐๐ž๐ซ ๐…๐จ๐ฎ๐ง๐๐š๐ญ๐ข๐จ๐ง ๐‚๐จ๐ฎ๐ซ๐ฌ๐ž ๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ: If you are absolutely new to Blender, take this foundation course. https://www.youtube.com/playlist?list=PLtV6EPHDRNQKluDLiAne9LmUZW31Vt9IX ๐Ÿ‘‡ ๐€๐ฅ๐ฅ ๐Ÿ๐Ÿ ๐‚๐ฅ๐š๐ฌ๐ฌ๐ž๐ฌ ๐“๐จ๐ ๐ž๐ญ๐ก๐ž๐ซ ๐ˆ๐ง ๐Ž๐ง๐ž ๐‡๐จ๐ฎ๐ซ: https://youtu.be/XwYSI37yMUo ๐Ÿ‘‡ ๐๐ฅ๐ž๐ง๐๐ž๐ซ ๐“๐ข๐ฉ๐ฌ ๐€๐ง๐ ๐“๐ซ๐ข๐œ๐ค๐ฌ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ): https://www.youtube.com/playlist?list=PLtV6EPHDRNQJSHKa5qbtWaT6KsY1bOV53 ๐Ÿ‘‡ ๐„๐š๐ฌ๐ฒ ๐Œ๐จ๐๐ž๐ฅ๐ฌ ๐…๐จ๐ซ ๐๐ž๐ ๐ข๐ง๐ง๐ž๐ซ๐ฌ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ): https://www.youtube.com/playlist?list=PLtV6EPHDRNQJEEOCoTRPf6z6DSnLru0ey ๐Ÿ‘‡ ๐Œ๐š๐ญ๐ž๐ซ๐ข๐š๐ฅ๐ฌ ๐˜๐จ๐ฎ ๐๐ž๐ž๐ ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ): https://www.youtube.com/playlist?list=PLtV6EPHDRNQJG_Dp8AgipRizpi6nEk97G ๐Ÿ‘‡ ๐€๐ฅ๐ฅ ๐“๐ž๐ฑ๐ญ ๐„๐Ÿ๐Ÿ๐ž๐œ๐ญ๐ฌ ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ): https://www.youtube.com/playlist?list=PLtV6EPHDRNQKj4S7hYAmRbmGM91XJF3ps ๐Ÿ‘‡ ๐‚๐š๐ฆ๐ž๐ซ๐š ๐Œ๐จ๐ฏ๐ž๐ฆ๐ž๐ง๐ญ & ๐’๐ž๐ญ๐ญ๐ข๐ง๐ ๐ฌ ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ: https://www.youtube.com/playlist?list=PLtV6EPHDRNQLDGPjwstDe5Z3D2plVeJmZ ๐Ÿ‘‡ ๐”๐ฌ๐ž๐Ÿ๐ฎ๐ฅ ๐‹๐ข๐ ๐ก๐ญ๐ข๐ง๐  ๐’๐ž๐ญ๐ฎ๐ฉ ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ): https://www.youtube.com/playlist?list=PLtV6EPHDRNQI38u5b-6YupR0pmsivk6xf ๐Ÿ‘‡ ๐‘๐ข๐ ๐ข๐ ๐๐จ๐๐ฒ ๐๐ก๐ฒ๐ฌ๐ข๐œ๐ฌ & ๐‘๐ข๐ ๐ข๐ ๐๐จ๐๐ฒ ๐‚๐จ๐ง๐ฌ๐ญ๐ซ๐š๐ข๐ง๐ญ๐ฌ: https://www.youtube.com/playlist?list=PLtV6EPHDRNQLTnVbeeZzZU7OIx_FUqwnC ๐Ÿ‘‡ ๐…๐ข๐ซ๐ž & ๐’๐ฆ๐จ๐ค๐ž ๐’๐ข๐ฆ๐ฎ๐ฅ๐š๐ญ๐ข๐จ๐ง ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ): https://www.youtube.com/playlist?list=PLtV6EPHDRNQJx8SXPn_e6QO1cNgDWAxVb ๐Ÿ‘‡ ๐…๐ฅ๐ฎ๐ข๐ ๐’๐ข๐ฆ๐ฎ๐ฅ๐š๐ญ๐ข๐จ๐ง ๐ˆ๐ง ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ): https://www.youtube.com/playlist?list=PLtV6EPHDRNQLTZLKXkBAIkDjKX9tSsjIA ๐Ÿ‘‡ ๐Œ๐š๐ฌ๐ญ๐ž๐ซ๐ข๐ง๐  ๐๐ฅ๐ž๐ง๐๐ž๐ซ (๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ): https://www.youtube.com/playlist?list=PLtV6EPHDRNQJ1sO47-fyWEOSGRMZOPbFk #Blender #Animation #WorldData #Excel Timestamp 00:00 Intro 00:30 Run script-1 to link with excel 01:20 Run script-2 for data comparison 03:02 Run the animation and verify 03:58 How to setup your camera

Download

0 formats

No download links available.

Create Data Comparison Videos From Excel Files | No Manual Work Needed | Setup Camera With PY Script | NatokHD