I'm a VBA coder, post ChatGPT, I'm easily able to code in python, in just one month, I'm able to write lenthy code to speed up my tasks, amazing AI tech, loving it.
Just a side note. ChatGPT can basically only handle really simple excel tasks, but it can give you a start if you are new. Also, these tasks for excel only work if your excel data is VERY clean... from my experience, data in excel files is never so clean. At my job, i always have to run multiple sets of blocks of logic code to determine how the value within a cell is setup in order to figure out what to do with that value in my program and to also detect errors. For example, I created a program that reads the requirements column within inspection reports. The cells in this requirement column contains both a nominal value and a tolerance. i have to run logic to figure out how to separate between the 2 in the cell if there is even both a nominal and a tolerance because sometimes the nominal is a range with no tolerance, then run logic to determine what type of tolerance it is if there is one, as a tolerance can take multiple forms, then I use some logic to determine what needs to be removed as extra stuff can appear within that cell as well that I don't want. Then I read the results column and run logic on it as the results can also take multiple forms. Lastly, based on the logic from the previous steps, it runs the correct calculation to determine the percentage (or highest percentage if ranged result) of the tolerance used up based on the result. Yeah , if our inspection reports were setup so that each item, nominal, low end of tolerance, upper end of tolerance, low of end of result, high end of result were each in inputted into their own column in the excel, then our excel inspection reports could all be evaluated incredibly simply and ChatGPT could do it................. but alas, they are not. I suspect many people run into this problem where data is not so clean.... yet every example on youtube shows perfectly clean examples of data input into an excel.
yep agree with this post, the deeper you dive into complicated problems esp in SWE jobs it just gets too complicated. i wish chatgpt could solve all my problems at work lol
This is awesome! As someone learning python at the moment for data analysis, this is great stuff! As a side note, you can merge the data of multiple files directly from excel without the need of python..just FYI
Thank you for you valuable video - this is what many of us need with real example of coding - great tutorials! I am learning how to become a data analyst and found that many companies still using spreadsheets - so I am learning python panda library to automate many processes that are slow in excel. more example like this video are very welcome
Hi i have a task of copying data from source excel which is xlsx to multiple xlsm file only selected sheets but im not able to do it is there any thing you can help on with
If you mean excel reporting, probably. The thing is, I didn’t find an easy way to make ChatGPT do most of the job. I think there’s a workaround that involves making ChatGPT use Pandas to do all of this, but I need time to test it out
Hey there, i hope you are doing fine !!! i have problem where is mycodde is unable to support relative referencing, absolute referencing and mixed formula, whenever i am am trying to insert the rows and copy values and formula, it is able to copy and values and formula but is not true for inserted cell, it is true for row above .... please help with the suggestion, Thanks !!!!
I have been working on an excel project in which I had to concatenate the data from multiple files. But in my case the number of rows exceeded excel's limit of 100,000 in one worksheet. So I was wondering, is there any other way through which I can perform excel actions using python without even concatenating the files, and bring the summary results in one seperate worksheet? Anyone please help as I don't really know what to ask from chatgpt in this regard. Thanks in advance
I would like to thank you for showing how ChatGPT can help with Excel queries. It is awesome. I am learning pandas library to move away from the slowness and crashing of excel, especially when files are linked to multiple files in other folders. I am good with formulas, but I don't want to learn VBA or power query, so I went straight to Python. However, is ChatGPT going to stunt my learning of the pandas library since it provides the code, or is it better to gain a working knowledge of pandas before using ChatGPT?
Hi! It depends on how you use the tool. If I were learning Pandas, I'd learn it with guides/tutorials and when I feel stuck I'd use ChatGPT to solve my questions. You only need to ask ChatGPT the right question and use it wisely to enhance your learning.
Really cool! Though in all of these examples I think I'd figure the python side out myself, faster than it would take me to learn how to use chatgpt effectively. But with more advanced examples I could see a major speed boost by using chatgpt.
GPT did not make a mistake. Tge human did. He told GPT that the excel file names did not end in '.xlsx' so he git what he asked for. If he wanted it right the first time, then he doesn't need to tell GPT the wrong thing.
WHAT??? IT DIDNT MAKE A MISTAKE! TGE HUMAN MADE THE MISTAKE. THE NARRATOR IS BLAMING THEVPROGRAM FOR DOINGVEXACTLYVWHATBITCWAS TOKD TO DO, AND ALSO BLAMING UT FOR HIS MISTAKE? 😮 WOW.
Cute but your prompts are so bad !! Not everybody knows how to use Python. VB is th epreffered language in Excel and DOS commands would be better to rename the files ! Much simpler ! CHATGPT To rename all Excel files in a directory and add "2022" to the front of the file name, you can use the following command: Answer for %f in (*.xlsx) do ren "%f" "2022-%f"
Why automate excel via Python when there is VBA and C#? Waste of time and very risky (you must relay on some open source library instead of Microsoft API)
I would like to thank you for showing how ChatGPT can help with Excel queries. It is awesome. I am learning pandas library to move away from the slowness and crashing of excel, especially when files are linked to multiple files in other folders. I am good with formulas, but I don't want to learn VBA or power query, so I went straight to Python. However, is ChatGPT going to stunt my learning of the pandas library since it provides the code, or is it better to gain a working knowledge of pandas before using ChatGPT?
If you'd like to know how I'd use ChatGPT to learn to code, check out my new video 👉ua-cam.com/video/Eh_KovOmQRQ/v-deo.html
Use cases for job freshers
What should my next ChatGPT video be about? Share your ideas below (but please don't ask ChatGPT this question😅)
maybe creating a modern event business website?
with inquiry, calendar, contact us, social media etc.
Make ChatGPT to create another ChatGPT and get the full code of it.
Create stock data analytics tool in excel using python.
I really want to know about SER (Speech Emotion Recognition) with live feed. 😅
Hello Sir I want Django.
I'm a VBA coder, post ChatGPT, I'm easily able to code in python, in just one month, I'm able to write lenthy code to speed up my tasks, amazing AI tech, loving it.
Just a side note. ChatGPT can basically only handle really simple excel tasks, but it can give you a start if you are new. Also, these tasks for excel only work if your excel data is VERY clean... from my experience, data in excel files is never so clean. At my job, i always have to run multiple sets of blocks of logic code to determine how the value within a cell is setup in order to figure out what to do with that value in my program and to also detect errors.
For example, I created a program that reads the requirements column within inspection reports. The cells in this requirement column contains both a nominal value and a tolerance. i have to run logic to figure out how to separate between the 2 in the cell if there is even both a nominal and a tolerance because sometimes the nominal is a range with no tolerance, then run logic to determine what type of tolerance it is if there is one, as a tolerance can take multiple forms, then I use some logic to determine what needs to be removed as extra stuff can appear within that cell as well that I don't want. Then I read the results column and run logic on it as the results can also take multiple forms. Lastly, based on the logic from the previous steps, it runs the correct calculation to determine the percentage (or highest percentage if ranged result) of the tolerance used up based on the result.
Yeah , if our inspection reports were setup so that each item, nominal, low end of tolerance, upper end of tolerance, low of end of result, high end of result were each in inputted into their own column in the excel, then our excel inspection reports could all be evaluated incredibly simply and ChatGPT could do it................. but alas, they are not.
I suspect many people run into this problem where data is not so clean.... yet every example on youtube shows perfectly clean examples of data input into an excel.
We get it... your job is REALLY necessary. Now breath. P.S. newer bots are going to take your job for sure.
yep agree with this post, the deeper you dive into complicated problems esp in SWE jobs it just gets too complicated. i wish chatgpt could solve all my problems at work lol
This is awesome! As someone learning python at the moment for data analysis, this is great stuff! As a side note, you can merge the data of multiple files directly from excel without the need of python..just FYI
I haven't used Excel since uni 😅 I've never heard of that functionality, You do it with Excel itself or you mean Power Query?
To be fair sometimes excel refuses to do the merge if something is off
You can do it with Excel VBA, Check Data Visualized video about that
@@ThePyCoach you can do it with power query fairly simple
Oh my God! Wonderful work...
Credit goes to you (and chatgpt, looks like it is doing the work :) ).
Thank you for you valuable video - this is what many of us need with real example of coding - great tutorials! I am learning how to become a data analyst and found that many companies still using spreadsheets - so I am learning python panda library to automate many processes that are slow in excel. more example like this video are very welcome
Hi i have a task of copying data from source excel which is xlsx to multiple xlsm file only selected sheets but im not able to do it is there any thing you can help on with
Wow! This is insane.
What are you using to write the code for testing
Can we use chatgpt for modelling and simulation like Monte Carlo simulation model
Never tried Monte Carlo simulation. Ask ChatGPT and let me know what you got
this is a great series
Can you make a video, showing chatgpt automating accounting?
If you mean excel reporting, probably. The thing is, I didn’t find an easy way to make ChatGPT do most of the job. I think there’s a workaround that involves making ChatGPT use Pandas to do all of this, but I need time to test it out
whtat is the application you use to run the Python scripts? I'd like how you order the files and run the scripts
You mean the IDE? If so, it's Pycharm
@@ThePyCoach yes that's the one. Thanks for sharing
Hey there, i hope you are doing fine !!!
i have problem where is mycodde is unable to support relative referencing, absolute referencing and mixed formula, whenever i am am trying to insert the rows and copy values and formula, it is able to copy and values and formula but is not true for inserted cell, it is true for row above ....
please help with the suggestion,
Thanks !!!!
I have been working on an excel project in which I had to concatenate the data from multiple files. But in my case the number of rows exceeded excel's limit of 100,000 in one worksheet. So I was wondering, is there any other way through which I can perform excel actions using python without even concatenating the files, and bring the summary results in one seperate worksheet?
Anyone please help as I don't really know what to ask from chatgpt in this regard. Thanks in advance
Really useful. Thanks for your video
Thank you very much. That was really helpful.
Hi, is there any video of Twitter streaming or storming?
I would like to thank you for showing how ChatGPT can help with Excel queries. It is awesome. I am learning pandas library to move away from the slowness and crashing of excel, especially when files are linked to multiple files in other folders. I am good with formulas, but I don't want to learn VBA or power query, so I went straight to Python. However, is ChatGPT going to stunt my learning of the pandas library since it provides the code, or is it better to gain a working knowledge of pandas before using ChatGPT?
Hi! It depends on how you use the tool. If I were learning Pandas, I'd learn it with guides/tutorials and when I feel stuck I'd use ChatGPT to solve my questions. You only need to ask ChatGPT the right question and use it wisely to enhance your learning.
Can it add to include this into a fully responsive html and css page.
Cool video, thanks!
Awesome video
You can do this very easily thru Excel using Power Query....
This is fire.....
so convenient that you always have exactly 1000 sales per month!
How to make android apps using chatgpt
how did u upload files to chatgpt?
Ask that gpt guy....
I can't sleep cause off ChatGPT the possibilities are endless.......🤔🤔
Same here
@@ThePyCoach combine with midjourney for bags under your eyes🤣🤣
Or you could dump all of those files into a db and fire a query
THANK YOU
Really cool! Though in all of these examples I think I'd figure the python side out myself, faster than it would take me to learn how to use chatgpt effectively. But with more advanced examples I could see a major speed boost by using chatgpt.
Great!
I hate + to concatenate strings. Use f-strings
GPT did not make a mistake. Tge human did. He told GPT that the excel file names did not end in '.xlsx' so he git what he asked for. If he wanted it right the first time, then he doesn't need to tell GPT the wrong thing.
start using the catchphrase "What a time tp use AI!" please hahahhaha
Good one haha. I have a catchphrase I used to hate, but would consider using “There has never been a better time to be alive”
Power query and power pivot is much easier
thumbs up!
Bro where you born and what is your native language? You speak english very fluent.
Seems cheesy. It simply does what I do on google already. Not much help
Funny, why are you making it yourself so difficult? Google Sheets does all these functions natively, Excel is soooo 2010...
Palatial
WHAT???
IT DIDNT MAKE A MISTAKE!
TGE HUMAN MADE THE MISTAKE.
THE NARRATOR IS BLAMING THEVPROGRAM FOR DOINGVEXACTLYVWHATBITCWAS TOKD TO DO, AND ALSO BLAMING UT FOR HIS MISTAKE?
😮 WOW.
Cute but your prompts are so bad !! Not everybody knows how to use Python. VB is th epreffered language in Excel and DOS commands would be better to rename the files !
Much simpler !
CHATGPT
To rename all Excel files in a directory and add "2022" to the front of the file name, you can use the following command:
Answer
for %f in (*.xlsx) do ren "%f" "2022-%f"
Why automate excel via Python when there is VBA and C#? Waste of time and very risky (you must relay on some open source library instead of Microsoft API)
Just say you dont know python and leave it there.
@@thefamousdjx yeah i am somewhat shocked to see comparisons between python and VBA. i mean clearly not even fair comparison to be honest!!
Bill Gates image will cause unsubs. Keep your vids neutral. Next, you will tell us that we can't watch your videos because we unvaccinated, lol
Recently solved this using something like pd.concat([pd.read_excel(f) for f in glob('. /sales_*.xlsx')])
I would like to thank you for showing how ChatGPT can help with Excel queries. It is awesome. I am learning pandas library to move away from the slowness and crashing of excel, especially when files are linked to multiple files in other folders. I am good with formulas, but I don't want to learn VBA or power query, so I went straight to Python. However, is ChatGPT going to stunt my learning of the pandas library since it provides the code, or is it better to gain a working knowledge of pandas before using ChatGPT?