Рет қаралды 199,725
I'm a supporter who provides information about Python programming!
This video is a video that tried automating Excel file operations with Python 😊
※ Subtitles use automatic translation, so there may be some mistranslations.
If you are using Excel files in your business and want to automate various processes, I would be happy if you could refer to it.
・How to get the file path
・How to read Excel files
・How to handle tabular data
I explain these
I'm actually running the Python code and demonstrating it, so I'd be happy if you could watch it to the end 😊
💙 Membership 💙
Explanation video ▶︎ • 【ご報告】本日からメンバーシップ開始します!...
Register ▶︎ / @pythonvtuber9917
For iPhone, click here ▶︎ PythonSuppl/statu...
🎥 Related videos 🎥
Folder path operation ▶︎ • 【Pythonプログラミング入門】フォルダー...
Excel operation ▶︎ • 【PythonでExcel操作!】OpenP...
Pandas ▶︎ • 【Pythonプログラミング】Pandasの...
Type annotation ▶︎ • 【Pythonプログラミング入門】タイプアノ...
💻 Operating environment 💻
Windows 10
Python 3.9.0
⭐️ Chapters ⭐️
0:00 Today's theme "Automating Excel operations with Python"
0:56 work contents
2:53 Get path of Excel file
4:49 Extracting data
7:45 Create a list
9:34 Excel file output
10:25 Change to date type
11:44 Refactoring
17:17 ending
💜 Channel description 💜
I'm a Vtuber Sapoo who explains Python programming✨
I will upload videos that are easy for beginners to understand and systematically learn Python!
I would be happy if everyone liked Python even a little 💕
I'm also on Twitter, so please follow me!
Twitter ▶︎ / pythonsuppl
Email ▶︎ python.supu.vtuber@gmail.com
#Python
#Exercises
#Automation
#Excel
#study
#python
#PythonVTuberサプー