Thank You, Laura, for this great tutorial ! No fluff and to the point - keep it up
@thefriendlycoder_2 жыл бұрын
This makes me happy! Thank you :)
@MrJohn2brown2 жыл бұрын
Amazing , this saves me a ton of repetitive copy pasting every Monday. Cant wait for more vids. Many thanks
@thefriendlycoder_2 жыл бұрын
Thank you so much!
@Oostenwald-s5qАй бұрын
You made this look very easy. Please, please, please make more of these Python videos. I extract information from 18 different Excel files and consolidate the relevant data from each file to create a report on a single Excel sheet. There must be an easier way to accomplish this, as my laptop struggles to execute all the commands and formulas I use.
@thefriendlycoder_Ай бұрын
Thank you! Great idea
@cdisla983 жыл бұрын
Really needed to see this tutorial!! thank you so much for this!!
@michaelcrain89262 жыл бұрын
I am just now learning python and this is just what I needed to start with. Thank you for making this.
@thefriendlycoder_2 жыл бұрын
Thank you!
@SalehGoodarzian2 жыл бұрын
I appreciate your helpful, concise, and very friendly video. It helped me a lot. I had spent hours to find a very short way to import all excel/csv files. Your video showed me the way. I really appreciate and I wish you all the best...I share what I did in only 5 lines, I can't thank you more (please note my code is saved in the folder with csv files...). files = glob.glob('*.csv') data = pd.DataFrame() for file in files: current = pd.read_csv(file) data = pd.concat([data, current], axis=0)
@akanobody56222 жыл бұрын
Perfect, thanx I have to do many repetitive excel sheet cleaning and this tutorial is very helpful for me, I just hope this can handle the amounth of data I work with.
@thefriendlycoder_2 жыл бұрын
This makes me so happy! I hope it works for you
@HartsoBig2 жыл бұрын
This was great! However, going to your channel only to see one upload was not! More videos! I would love to see you continue this sleep data project and automate turning the data into visuals. Thanks!
@bleharris47022 жыл бұрын
You're a star, very simple and to the point tutorial. Thank you.
@thefriendlycoder_2 жыл бұрын
Thank you ✨✨✨
@deepakhaldar29835 ай бұрын
keep upload new videos, you have just saved my hours by this. Thankyou. Can you please make a video on sharing Auto Mail to different stakeholders with attachement of their mentioned data.
@thefriendlycoder_5 ай бұрын
Thank you! A great suggestion :)
@binarystar4947 Жыл бұрын
Welcome to you tube :) and wanted to see more of the videos related to pandas tips and tricks
@patrickwheeler71073 жыл бұрын
Thanks for putting this together! Would love to see you add some logic to look for last row of an empty data set and omit the rest of the rows, like foot notes from some reporting systems. EIther way this was very helpful!
@thefriendlycoder_3 жыл бұрын
Thanks Patrick, good idea!
@patrickwheeler71073 жыл бұрын
@@thefriendlycoder_ Thanks for replying. Here IMO would be a fantastic project to run through. You have several files. All the same column length. a couple of real world examples I run into. As mentioned looking for the last record, maybe blank, or a specific word or length of word. Delete a column or columns Delete a row Rename missing values to something to group them correct in a column. I am mainly an SQL developer and use some VBA when unable to use our ETL tool so learning Python is really helpful for me. Thanks!
@robertspalding56352 жыл бұрын
I am only a beginner but this was incredibly cool and so are you. thank you.
@thefriendlycoder_2 жыл бұрын
Thank you!
@noahinaus Жыл бұрын
Laura, you seem like a night owl! XD Thanks for the great tutorial and I really like your energy all along 😁
@sirajmultani57242 жыл бұрын
Thank You Laura, it really helped me and saved hours of work. I really appreciate! please keep up the good work !!!
@thefriendlycoder_2 жыл бұрын
Thank you Siraj!
@MuhammadAdeelAhmed2 жыл бұрын
Thank you Laura, something I learnt today, very well explained, excellent work
@thefriendlycoder_2 жыл бұрын
Thank you!!
@rikardoledal22702 жыл бұрын
Thank you!! I love excel and are now learning to code Python. It was a great video. I'm subscribing :)
@thefriendlycoder_2 жыл бұрын
I love to hear that! thank you :)
@jenniferdios3 жыл бұрын
pandas is so awesome. Need to get more familiar with it. Thanks for this tutorial!!
@johnobiomah222 жыл бұрын
Thank you. This worked perfectly for what I needed it for
@call-me-potato. Жыл бұрын
thanks madam for such a nice tutorial , I just started learning programming. no previous back ground . kindly please make more easy videos and please increase size of your screen its very small. and wall paper on your screen is amazing. kindly any one who is reading my comments , advice me on python , what things should i learn initially.
@thefriendlycoder_8 ай бұрын
Thank you so much! Will take all of this into consideration.
@user-lp1iu4eo5s Жыл бұрын
Explained it very clearly.... Thank u 😊
@LanceToledo3 жыл бұрын
So proud of you Laura!!!
@thefriendlycoder_3 жыл бұрын
Thanks Lance :')
@zeinplayy Жыл бұрын
Best tutorial ever, thanks🎉
@SuperNunera Жыл бұрын
Gonna use that today ! Ty for sharing !
@anujsaxena82683 жыл бұрын
Really Appreciable, Much helpful 💕 Please do make more videos on Numpy and Pandas facing much errors in this
@thefriendlycoder_3 жыл бұрын
Thanks for the encouragement Anuj!
@anujsaxena82683 жыл бұрын
@@thefriendlycoder_ Most Welcome
@shubhamgade71803 жыл бұрын
Thanks for the content!! If possible can you make a tutorial on joining 2 excel sheets on basis of one common column between the two files? So as the values in second excel with join the values in first excel.
@noeldoller29582 жыл бұрын
great work Laura. Please do more excel automation specially showing how to copy range of cells from multiple excel files to a single master file, please
@theshuffle0409 Жыл бұрын
Great explanation Laura...
@miladghalehnoei83002 жыл бұрын
it was very helpfull for me. thank you so mach
@ngrunoz2 жыл бұрын
Thank You Laura for the great tutorial. I have a scenario were I would like to combine only sheet with same name from various workbooks and either write each sheet for similar sheet names or a concatenated csv file for similar sheet names.
@michaelventarola71003 жыл бұрын
Liked your tutorial. Would like to do lookups from one sheet to another. That would be a great tutorial.
@lordprocessor72532 жыл бұрын
You leave me no choice….”subscribed”
@thefriendlycoder_2 жыл бұрын
😂😂😂 thank you!
@temukaify2 жыл бұрын
Really nice. I wish I also had a video how to delete all the rows that I don't need and combine files in a column fashion - join by columns.
@temukaify2 жыл бұрын
+1 request - Please zoom in on codes, because it's difficult when they're so tiny.
@thefriendlycoder_2 жыл бұрын
Thanks for the feedback :)
@terrytolbert30982 жыл бұрын
i am a heavy VBA (Excel/ Access/PowerPoint) user and always wondered how Python could also do the same things. can you also please show me how Python can do these. - auto find the last row/ column of data, if the data has gaps. - find a sheet in a excel workbook find (multi sheets, and you only want data from 1).
@miltondiaz25312 жыл бұрын
Hola Laura, tu video hizo que resuma mi codigo a de mas de 10 filas a 4. Saludos desde Perú. Gracias
@thefriendlycoder_2 жыл бұрын
Gracias! ☺️
@rmscrisostomo2 жыл бұрын
Thank you so much, this is a very good tutorial! Congratulations!
@thefriendlycoder_2 жыл бұрын
Thank you! :)
@gmagcaling2 ай бұрын
Very helpful!
@thefriendlycoder_2 ай бұрын
Thank you!
@shivkay18 күн бұрын
Can you do a video on how to update one worksheet with another one…. And also to refresh all pivots that are linked to the first sheet
@deepanshusingh60572 жыл бұрын
Beautiful Content
@thefriendlycoder_2 жыл бұрын
Thank you! :)
@dalixolombuyane5119 Жыл бұрын
Love it. Thank you
@utkarshtripathi9118 Жыл бұрын
U Healed me alot Thank U Thank u so much
@sureshn39512 жыл бұрын
Hey Laura, This tutorial is very Helpful. Can you please do another video on how to combine cols by cols. thanks
@iceiceisaac2 жыл бұрын
Nice, please keep posting
@thefriendlycoder_2 жыл бұрын
Thank you!
@fafa58412 жыл бұрын
thank you so much. can you make a video on how to read specific cell value/column/ raw from multiple workbook or sheets and combine it into a new excel file?
@thegracegong2 жыл бұрын
thanks queen
@thefriendlycoder_2 жыл бұрын
💓
@jessesmith22503 жыл бұрын
when running the script at 6:31 I get the following error message: AttributeError(f"module 'pandas' has no attribute '{name}'")
@mhmoudkhadija38392 жыл бұрын
Thanks! This tutorial is really useful..
@thefriendlycoder_2 жыл бұрын
Thank you!
@cdlowe32 жыл бұрын
This was very helpful - Thanks for putting this together. How would you format the cells?
@sravankumar1767 Жыл бұрын
THANKS 😊 NICE EXPLANATION 👌 👍
@PONCEJE7 ай бұрын
You are fantastic thank you for video.
@thefriendlycoder_7 ай бұрын
Thank you!!
@PONCEJE7 ай бұрын
Waiting for more videos.
@Frank-si2jd Жыл бұрын
Hi Laura, thanks for your very well done tutorial and using this helpful example! Question though; I understand having Python and adding/including libraries like Pandas and Glob and the necessity to have them installed on your computer to be able to program. But what if I hand this compiled executable program over to a friend, does he needs to have Python, Glob and Pandas installed on his computer? Or is running the executable enough for him? I do understand I also need to fix the location (path) of his Excel file on his computer in the script.
@aleksandrekacharava2318 Жыл бұрын
Thank you for the great info! One more question: can we keep cells' format while combining the files? For example, if there is some color in certain files' cells and we need to keep them in those colors. Thank you.
@gloriachica9862 жыл бұрын
Thank you Laura
@sravankumar1767 Жыл бұрын
How can we convert each xlsx sheet as single csv to load to destination. Can you please explain this scenario
@torque63892 жыл бұрын
Great video, thank you!
@thefriendlycoder_2 жыл бұрын
Thank you!
@arielmoraes99603 жыл бұрын
Wow great video!!!
@anselmeouohi7914 Жыл бұрын
Really good tutorial ! How about if we want to compare data in dataframe before concatenate?
@TajMikel11 ай бұрын
Why no more tutorials? This one was really helpful!
@thefriendlycoder_8 ай бұрын
Thank you for this comment! I posted another video
@marceloestrada1934 Жыл бұрын
thanks Laura! amazing tutorial! I have many excel files but with different headers. How can I match or concatenate headers with similar names or a condition that include one word for each column in each file?
@siyakholwakhiphi15562 жыл бұрын
That's great staff, I emulated the code and it worked only on your spreadsheets but on the ones I want to use, kind to explain what could be the problem? Thanks in advance
@hirengajjar41592 жыл бұрын
i want to marge multiple excel, all excel have common 3 sheets. please help to get code for the same, i want all data merge in new blank excel sheet wise
@blankseventydrei2 жыл бұрын
nice work and I learned alot, and will put it to use, but why do this in python when it can be done with VBA? what would be the advantage?
@ahmedabdelaziem4497 Жыл бұрын
Many thanks
@neeljain51692 жыл бұрын
Thanks for the great tutorial ! I am trying to combine two excel files using your code. But its not reading the hyperlink values and I am getting N/A in that column. Could u pls suggest what changes can be done to have the hyperlink values as well.
@bluchips20552 жыл бұрын
That was good, thanks.
@tranngocquynh942 жыл бұрын
Hi Laura, I have just following your tutorial. However, i have duplicate headlines that need to be removed, can you share how can we delete it? Thank you so much
@cuneytozkurt48672 жыл бұрын
Hey, it's really great!!!
@kudakwashejena16672 жыл бұрын
Thank you for this. Can I combine sheets into one if I’m dealing with more than 3million rows of data?
@nasserabdal5236 ай бұрын
Thank you very much on this explan But i ask about copy of format excel file as color and bolt text for each file when i combine in one
@thefriendlycoder_6 ай бұрын
Hi! For formatting (e.g, adding color, making text bold) I suggest using the library openpyxl instead of pandas.
@mariachica69133 жыл бұрын
Thanks, I will try ❤️
@kabirgive93562 жыл бұрын
Really helpfull could you please tell me could I append each excel file and then save all the data generated into a single excel file please it would be really helpfull
@mattviverette2 жыл бұрын
Can you think of a way to reorder the sheets so that the month names are in the correct chronological order without numbering the month names?
@ryanrumsey28302 жыл бұрын
Hello Laura .. loved your video. Can you do a video on combining data from multiple excel files using a "Vlookup" to search for certain data?
@thefriendlycoder_2 жыл бұрын
Good idea thank you!
@akhgh072 жыл бұрын
really helpful thank you
@thefriendlycoder_2 жыл бұрын
Thank you!
@beginho24542 жыл бұрын
Nice and pretty teacher.
@d515144d Жыл бұрын
Thank You
@kamrank6803 жыл бұрын
Thanks!! It helped me
@thefriendlycoder_3 жыл бұрын
That's awesome! Thanks for the feedback :)
@samahmedalone65732 жыл бұрын
Thanks, 👍👍👍
@Karimahmedsaleh Жыл бұрын
I`d like to thank you for your great video, but I also tried and didn`t work with me, I don`t know what`s the reason
@sainbayarzorig2 жыл бұрын
thans you very much
@williamstanes13812 жыл бұрын
Hello Laura , i have a doubt about combining different files to single files but in a different sheet
@williamstanes13812 жыл бұрын
Is there any platform so i can post my query and you can help me with it
@aseemtripathi35552 жыл бұрын
How Laura can you please guide me how to fetch only current date excel files from specific time frame
@gloriachica9863 жыл бұрын
Wow ,Thanks 😘🕊🙏🏻
@allanrasmussen57892 жыл бұрын
it's fine what you're doing, but you need to set the font size up
@evelic Жыл бұрын
Hum, interesting, Python is blazing fast to process all this stuff.
@fernandoortiz60692 жыл бұрын
great job
@thefriendlycoder_2 жыл бұрын
Thank you!
@bluchips20552 жыл бұрын
If you could, please be encouraged to put in some SUMIFS and VLOOKUP tutorials on python.
@Saurabhdeepsinghdeopuri3 жыл бұрын
i cannot be able to run at 6.45, error show (warning: Workbook contains no default style, apply openpyxl's default) help[ me to resolve issue
@thefriendlycoder_3 жыл бұрын
Hey Saurabhdeep, does the code run before 6.45 for you?
@mohamadhabibhomeidi56343 жыл бұрын
Great....
@FahmiFashaApridiansyah2 жыл бұрын
I always get ValueError: Invalid file path or buffer object type:
@Smolenishev2 жыл бұрын
Thanks!
@thefriendlycoder_2 жыл бұрын
Thank you!
@heythemhamlaoui23923 жыл бұрын
thank you
@jonelatendido98367 ай бұрын
Could I use Visual Studio, Instead of IDE?
@thefriendlycoder_7 ай бұрын
Yes! Visual studio is a type of IDE
@pankajgaurr2 жыл бұрын
How to do it for csv files??????
@thefriendlycoder_2 жыл бұрын
1) change the extension from .xls or .xlsx to .csv 2) change pd.read_excel to pd.read_csv 3) change .to_excel to .to_csv
@karthikrajamony60442 жыл бұрын
getting error as "ValueError: Excel file format cannot be determined, you must specify an engine manually."
@thefriendlycoder_2 жыл бұрын
Hey! Are all your excels closed?
@karthikrajamony60442 жыл бұрын
@@thefriendlycoder_ yes, all are closer
@nick-oi1xf7 ай бұрын
It might not be an xls file, it could be an xlm file, even though the extension is xls. Open it as a text file and check.
@komangsengku1332 жыл бұрын
thanks
@alikhanak1232 жыл бұрын
Hi can you make a video on this scenario Multiple files with multple sheets, merged to one file, with all sheets in thoes multple files. If sheet name in all files are same data should concat.
@ngrunoz2 жыл бұрын
Hi Randoms. Did you manage to find solution on this one. I am also trying to find solution on it.
@alikhanak1232 жыл бұрын
@@ngrunoz half way... I wanted, if File 1 2 & 3 all have sheets A B C.. And output file should have Sheets A B C with all data from files 1 2 &3 under respective sheets name
@ngrunoz2 жыл бұрын
@@alikhanak123 that is great. It looks like the exact same solution I am looking for. If you comfortable sharing the solution you have.
@alikhanak1232 жыл бұрын
@@ngrunoz I will share the work I have done half way, in a while. It is not successful, may be you can make it successful.
@shreya46762 жыл бұрын
How to convert csv files into one excel sheet in different tabs ? Please help
@umara9412 жыл бұрын
Do you still need help with your csv files?
@shreya46762 жыл бұрын
@@umara941 Yes, please If you can.
@umara9412 жыл бұрын
@@shreya4676 okay, let's discuss it. Do you have email, discord or telegram that we can use to discuss it and share files?
@robertreed4337 Жыл бұрын
excellent +++++++
@thefriendlycoder_8 ай бұрын
Thank you!!
@atangbingana28311 ай бұрын
Hey did you give up ? keep going ✊❤
@thefriendlycoder_8 ай бұрын
Thank you for the encouragement! I just posted another video!
@atangbingana2838 ай бұрын
Thanks for coming out of retirement - time to build 👊🏽 @@thefriendlycoder_