ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
YOU WILL NEVER PERFORM VLOOKUP AGAIN.. WATCH TILL END…
ฝัง
- เผยแพร่เมื่อ 2 ก.ย. 2021
- This video will teach you how to automate Vlookup in Excel with Python using the Openpyxl library. Increase your productivity by automating vlookup. Watch now and become a master of replacing Vlookup with Python automation using Openpyxl!
can we get the source code of this
You can find code here. pastebin.com/NjpRepNd
Your tutorials rock! Everything use works as you describe and I wonder if you teach as your profession. Subscribed, liked, and bell! Awesome!
would be super appreciated videos for pivots and indexmatch also!
Thank you so much
Your lesson is so good.
Wonderful buddy , great video , I have been looking for such type of automation from 2018 but couldn't find, This one really helps 😀 , great job tons of thanks for the video .
Perfect, bhai if we have 120+ columns then do you think that firstly we need to count the columns in excel...it's not the right way to do in industry level
Woww... really amazing.......I tried various area for 3 hrs ..not got what I want....but here...with only just this video I got it ..great...
thanks a lot.....
Very nice Presentation and more clear, Thanks a lot sir
Awesome 👍
Being a new python learner, this was really helpful and great explanation.
thanks for saving us from excel misery
Very nice tutorial and the way you go back and forward between the code and explaining what needs to be done in the sheet and what the code is doing in the Excel-sheet is incredible helpful. Is there a way, to automatically put rows in order of date?
This may require some pre-processing but it's possible. I will add a short tutorial for this in next couple of days.
@@python-bits Thanks! Hope you can send me a short answer when you have it online. You are doing a wonderful job here and this is highly appreciated by us the viewers!
Just added a new video on sorting. Check it out here: th-cam.com/video/Cn1TTQZ4Opg/w-d-xo.html
@@python-bits Hi Python Bits, thank you very much for your incredible fast response in creating this tutorial!! Well done!
Thank you.. Can you do this using arrays for both the sheets (master sheet and daily sheet). Please share if you have an example.
Thank you soo much, it's helps me in my projects ❤
Thank you very much🤩
Good good good.
But I'll personally go with Pandas instead
Thank you so much. Very kind and great lecture.
Glad it was helpful!
I love this.. Perfect
Now can you make a video on Index/Match?
Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.
thank u so much ......exactly what im looking for :)
Thank you, helpt alot!
Nice. Very helpful.
Glad it was helpful!
Thanks for the video.
Could you please do the same thing but using pandas?
pandas will remove all formatting and formulas of the file.
Thanks
If there is multiple master excel data then how can i vlookup the data. Need your help on this.
You will need to create multiple worksheet objects like we did for daily_sheet and master_sheet and iterate over each one of them and run a comparison.
Thank you 😊
Hey, I am able to vlookup..... but on my mastersheet only the values are getting printed, not along with the column names. Is there anything I should do, Please help !
thanks gan
Thanks a ton
For heading is not printing in final shee
Nice, but using pandas seens to be easier
this will not going to work for large data set.
I am facing error in import openpyxl. Kindly suggest what shall I do.
Make sure to install openpyxl package using 'pip install openpyxl' before importing it.
please add code so as enable to copy and use
Will start adding them. Thanks for the feedback!
beutifuly explained but code not included with video
Glad it was helpful!
It works but if you use a 41k rows pfff!!!
If you have a large file, you can store data in objects (or other data structure, probably list of dictionaries), perform your logic operation and then save that compared data into new excel file.
using pandas is better
I don't know ur English