filmov
tv
Python in Excel! Part 6 - Using Python to restructure data! 🐍🤩
Показать описание
Guys. I tried. I did. Honestly.
I really tried not to turn this into a Python tutorial. Buuuut... there's only so much "press this button to get that candy" we can talk about before we start to ask ourselves:
- Why bother using Python?
- What's the point?
Or before we convince ourselves:
- I can do this with a formula
- I'll stick with Power Query
I mean yeah. You could. It's definitely doable. LAMBDA and dynamic arrays mean there's very little you can't do.
But there are some things that are just SO much easier with Python.
Let's look at a challenge posted last year by Wyn Hopkins regarding expanding a range of Ticket Numbers.
At the time this was a perfect opportunity for LAMBDA, so I created a generic solution called STACKER which has proved useful over and over again since then.
If you haven't watched the STACKER videos yet and you're interested in advanced LAMBDA solutions which have nothing to do with Python, please take a moment to watch the videos linked in the comments.
Anyway, in this video I have a go at solving the challenge with Python.
Knowing the kind of data we often see in Excel, I have a feeling this is going to become your new best friend.
Let me know what you think in the comments and don't forget to like/share/subscribe for more! 💬
#data #analytics #excel #python #dataanalytics
I really tried not to turn this into a Python tutorial. Buuuut... there's only so much "press this button to get that candy" we can talk about before we start to ask ourselves:
- Why bother using Python?
- What's the point?
Or before we convince ourselves:
- I can do this with a formula
- I'll stick with Power Query
I mean yeah. You could. It's definitely doable. LAMBDA and dynamic arrays mean there's very little you can't do.
But there are some things that are just SO much easier with Python.
Let's look at a challenge posted last year by Wyn Hopkins regarding expanding a range of Ticket Numbers.
At the time this was a perfect opportunity for LAMBDA, so I created a generic solution called STACKER which has proved useful over and over again since then.
If you haven't watched the STACKER videos yet and you're interested in advanced LAMBDA solutions which have nothing to do with Python, please take a moment to watch the videos linked in the comments.
Anyway, in this video I have a go at solving the challenge with Python.
Knowing the kind of data we often see in Excel, I have a feeling this is going to become your new best friend.
Let me know what you think in the comments and don't forget to like/share/subscribe for more! 💬
#data #analytics #excel #python #dataanalytics
0:05:25
Download, Transform and Write Data to Excel with Python || Stock Analysis with Python Part 6
0:16:55
Python Pandas Tutorial (Part 6): Add/Remove Rows and Columns From DataFrames
0:00:25
So benutzt du Python in Excel! #excel #python #Microsoft
0:04:55
Decoding Excel Workbook Structure Part - 6
0:04:36
Grab Columns and Rows From Spreadsheet - Python and Excel With OpenPyXL #6
0:44:20
Extracting time series data from MULTIPLE netCDF files into a CSV (Part 6)
0:15:39
Grids Course Part 6 - Pulling Excel Data To Grid
0:00:14
UPSC VS IIT JEE 🥵 #iitstatus #motivation #toppers #iitjee #jeemains #upscstatus #neet #nit #jee
0:21:40
Power BI Training from SQL School I #powerbi #training
0:00:13
It’s literally perfect 🫠 #coding #java #programmer #computer #python
0:00:23
HOW CHINESE STUDENTS SO FAST IN SOLVING MATH OVER AMERICAN STUDENTS
0:00:41
How To Read Data From Excel Using Python !!! | Python Tutorial #shorts
0:00:14
How to create graphics using Python turtle 🐍🐢 #coding
0:00:06
xavier memes #memes
0:00:12
JEE Aspirants ka Sach 💔 #JEE #JEEMain #Shorts
0:00:21
Normal People VS Programmers #coding #python #programming #easy #funny #short
0:00:16
Python or Java? #codingninjas #coding #java #python
0:00:32
Python WEB SCRAPING in 30 Seconds! 🔥👨💻 #shorts
0:00:11
First python program🤞|| print 'Hello world!' in python 😇#pythonprogram #HelloWorld #print...
0:03:04
Python GUI (Tkinter) Tutorial: CSV/DataFrame Viewer - Part 6 - Display DataFrames in Treeview Widget
0:00:23
This character🥵🔥 #cobrakai #edit #viral #shorts
0:00:31
Clean Messy Data - Part 1 | Excel Tips and tricks | #shorts
0:00:20
Cobra Kai season 6 part 2 ☠️ #cobrakai
0:02:47
Pandas Part 6 - The value_counts() function
Комментарии