This lesson would take more than 30 minutes for others to explain. Great pace & clarity. This is usually the best way to explain something for non-beginners. This is the essence! Thank you so much!

Sorry for the technical errors on this one (learning premiere and animations to improve the videos haha) - Medium & Advanced level techniques coming soon!

@soy34mb

4 жыл бұрын

Hi, great video. Is it possible the output to MS Access file instead of Excel File? The reason is because I would like to combine thousands of excel files and the quantity of rows of the output will be more than 60mm.

@ashleyramirez87

4 жыл бұрын

Derrick Sherrill new stuff I just learned!

@user-fp1pf7dr5j

3 жыл бұрын

Where is live

@luisfernandocuestasanchez4343

3 жыл бұрын

Don't even worry about that man. You are doing God's work, thanks a lot. For all of us who have administrative jobs, this kind of content is amazing and I think college, at least in my country doesn't give us that (They didn't even taught us Excel). Now that I got out of it I will try to learn by myself and also with the valuable help of people like you. I have recently found in KZread more than all the courses of my university. Thanks for the inspiration and being a role model too.

@adamdenver8019

2 жыл бұрын

i guess im asking randomly but does anybody know of a tool to log back into an instagram account?? I stupidly forgot my account password. I appreciate any assistance you can give me!

Love😍your videos... So clear and straight to the point...high quality

This guy is going places! It wasn’t too long ago when I watched one of your videos and you only had a couple thousand subs. Keep up the great work! Love your videos

Really sweet person knows what he is doing and is not all about money and friggin sponsors. Keep it up! Makes me cry happily!

This tutorial is great, thank you so much!

Just stumbled across this. Thanks so much - a clear, easy to follow example. Great stuff!

dude thank you so much for this tutorial. i can't thank you how helpful you are to the data analysis community!

You have no idea how valuable this is to me. Thank you so much. Great content!

Great content. I don’t see enough people talking about excel -> python.

You are such a blessing. Subscriber from the Philippines here

Brilliant video, I have heard python mentioned numerous times but never seen it in action. Looks amazing, thanks for making the video!

Holly.. you just convinced me of the worthiness of learning to program. I could automate 90% of my job!! Thank you

I have a lot of things to learn from you man. Keep your videos coming up! Thanks

The pacing of your videos is perfect.

Clear and straight to the point. Good stuff.

KZread's algo popped up your video and this the first video to watch on your channel and I am subscribed to it. Thanks, this has been a great relieve for my production planning, though I am new in python.

Hi Derrick, I was nine when Apollo 11 was launched so, despite the difference of timelines between you and me, I feel very enthusiastic about my Python learning curve. I will utilize your instructive videos in order to implement a project on a native american language I am learning here in Central America. As things go further in my idiom classes the more rules appear, therefore I am expecting about storing different sources in different Excel files and combine them, with the proper sintactic rules, in some sort of a centralized dictionary. I have recorded the important features of this video for further use. Thanks.

So glad I found your channel!Thanks Derrick!!

Thanks, Derrick. Great job. I have worked with excel for over 15 years, manipulating data with excel multiple functions. But I still give credit to python and other programming languages for data automation. I'm transitioning.

Thank you for sharing your knowledge on Excels.

Thank you for sharing your knowledge! Very useful easy to understand! 👍

Wow this was really straightforward and easy to understand.

I'm going to drop all professionalism and just say " holy shit "". I've watched ALOT of training videos On python but WOW...it was short, clear, concise, and understandable. I know the video is 2 yrs old but I hope he is having all the success he deserves!! Well done!!!!

Excellent demonstration of functionality 🤙🏽

Brilliantly explained....I have been trying to learn python since 6 mounths........only this Guy made python easy for my dumb mind....

really good stuff. videos like these are great because we're doing real work and it helps me learn! thanks again.

Amazing Tutorial, Derrick. Thank you so much :)

Very short and crisp video...to the point....Thanks

Great Video! Helps me alot in day to day work. Thank you Derrick.

This is so great! Thank you Derrick!!

Thank you Derrick, great explanation!! You won a subscriber and a thumbs up. God bless you

Great content dude. I am newbie, and learn a lot from this video! Thanks!

really very clear in conveying the things opened a new way to process my excel files thank u so much

I really enjoyed the video. Concise and informative. Thank you

Muchas Gracias Derrick, excelente tu video. Saludos desde Argentina.

another outstanding video on python/pandas/excel tech!

I'm from Indonesia and I support this channel

Derick you are doing a great job. God bless you.

I really like your videos, like I’m purely a beginner but I feel like I learn a lot from your videos (and I already wrote some codes to automate excel tasks). Can you do more how python can be used to automate excel. Thank you and keep up your good work.

It’s crazy how well you describe everything. Your clear and slow speaking is great for tutorials. Thanks a ton!

@omkarpatil2254

Жыл бұрын

Because he is robot

This is a great tutorial! Great job!

you are the best, straight to the point

wow thank you so much for the great tutorial. This is gold.

thanks for a great vid! truly grateful being walked through this stuff

Hi Derrick, that was awesome! I'll make sure i'll check your content on Udemy as well :)

Thanks for the tips and I humbled to say that I never heard of some of these tools before this video. Accordingly, I have subscribed. Again, thanks, and God bless

Я новичок, но все понял. Очень классно объясняешь :) I’m just a beginner, but understood everything. You do it great :) Привет из России!

Good job. Thanks for sharing your knowledge

Very well explained! Thank you!!

Thanks for sharing this knowledge, I appreciate it too much!!!

Really great tutorial!

Amazing content here. Auto subscribed. Cheers from Spain :D

This video is really helpful. Thank you.

Very nice Tutorial. Thank you!

thanks, i learned so much from your videos

that was awesome video, i 'v never been seen one like that , thanks for your time my friend

Your channel is so underrated.

this is simple amazing!!!! thank you for the video..

I never thought David Bowie was into computers!

@NathanColmenero

3 жыл бұрын

We could be heroes!!

@Brutserum

3 жыл бұрын

Lmfao

@azizmiya

2 жыл бұрын

Lol, this David Bowie is a real rock star

@drn_lvs

Жыл бұрын

Just for onde day...

@luismontero3416

Жыл бұрын

🤣

Very Good Video Derrick!

thanks for the upload this video. i wasn´t have idea how to use python for read excel. one greeting from argentina

Amazing mate!!

I am very glad that you are more used to be the tutor in youtube. Thanks for providing the material with link! Thanks for your video, really liked them all.

Amazing. You made it so easy.

You have done a great and simple video to understand pyexcel in combo thank you bro😀😀😀

I have seen power query more useful so far, I have been making interactive dashboards out of raw data from multiple excel sheets and when new data is updated in sheets just press refresh button and job done.

@sreejithpnair8973

3 жыл бұрын

COPY FOLDER NAMES TO EXCEL in ONE GO kzread.info/dash/bejne/naWKzLWMmrnUm9Y.html

@AXLAV

3 жыл бұрын

"so far" ... thats' why

Very informative . God bless and keep posting

very helpful tutorial bro Thank you!! love from india ❤️

Interesting!! Thank u this was very helpful👍🏻

Very good one. I liked that you cared to mention which Python Version you we using.

Great video! I’m just getting into python to be able to pull data from webapi and convert json to csv. That would be a great video!

Have to agree with the other Power Query comments - automating Excel reports using Power Query is super easy, built into Excel, and no coding required! People should look at the many KZread tutorials to familiarise themselves with it. I'm not sure why you'd go to Python for the scenarios noted - Power Query is way more user friendly (built into Excel), less error prone, and low code to use Power Query. And apparently much quicker. I'm surprised from looking at the rest of people commenting and the number of likes this video received! Clearly people are not familiar with Power Query! Its like using a sledge hammer to crack a nut :)

Derrick you are super cool thanks for sharing your knowledge

Subscribed i dont know anithing of panda, python, automatization, excel but your explaination ets so clear that i want to learn whatever u are saying.

Thank you for sharing your knowledge

you made very good use of 10 minutes

Thanks Derrick that was really helpfull

1st step to analytics,thx

This tutorial is very useful... 👍👍👍

Learn a lot. Thank you.

Very Useful Buddy Keep It Up !!

Thank you so much Derrick

Great tutorial! 👍

I need to practice in order to understand it. But thanks for the lessen. It is informative.

To the author. This is a great demo of an important topic. Thumbs up +1 from me.

Great Video!! Thank you for sharing your knowledge:)

A really excellent video!

Thanks for your sharing !

thank you for your explaination.

Nice to do this exercise,quite some good teaching i must admit.

great work, thank you!

Thanks Derrick!

Very useful, thank you

Thanks a lot for the video!!

Good one, bro !!

Let’s gooooo!!!!

Awesome! Thanks! Would greatly appreciate if you could answer my question in your ""Replace Vlookup with python" video.

Great work!

Great tutorial! am about to be a regular to your channel.