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)
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.
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.
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!
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.
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_ 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!
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.
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.
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.
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?
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
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.
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
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.
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?
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.
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).
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
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
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
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.
@@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
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
Thank You, Laura, for this great tutorial ! No fluff and to the point - keep it up
This makes me happy! Thank you :)
Amazing , this saves me a ton of repetitive copy pasting every Monday. Cant wait for more vids. Many thanks
Thank you so much!
Really needed to see this tutorial!! thank you so much for this!!
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)
Welcome to you tube :) and wanted to see more of the videos related to pandas tips and tricks
I am just now learning python and this is just what I needed to start with. Thank you for making this.
Thank you!
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.
Thank you! Great idea
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.
This makes me so happy! I hope it works for you
You're a star, very simple and to the point tutorial. Thank you.
Thank you ✨✨✨
Explained it very clearly.... Thank u 😊
Thank you. This worked perfectly for what I needed it for
Laura, you seem like a night owl! XD
Thanks for the great tutorial and I really like your energy all along 😁
I am only a beginner but this was incredibly cool and so are you. thank you.
Thank you!
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!
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.
Thank you! A great suggestion :)
Thank You Laura, it really helped me and saved hours of work. I really appreciate! please keep up the good work !!!
Thank you Siraj!
precise and onto the point!
Thank you!!
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!
Thanks Patrick, good idea!
@@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!
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.
Thank you so much! Will take all of this into consideration.
Thank you Laura, something I learnt today, very well explained, excellent work
Thank you!!
So proud of you Laura!!!
Thanks Lance :')
Great explanation Laura...
Best tutorial ever, thanks🎉
Thank you!! I love excel and are now learning to code Python. It was a great video. I'm subscribing :)
I love to hear that! thank you :)
Gonna use that today ! Ty for sharing !
when running the script at 6:31 I get the following error message: AttributeError(f"module 'pandas' has no attribute '{name}'")
pandas is so awesome. Need to get more familiar with it. Thanks for this tutorial!!
Beautiful Content
Thank you! :)
it was very helpfull for me. thank you so mach
thanks queen
💓
Love it. Thank you
Very helpful!
Thank you!
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.
Thank you Laura
U Healed me alot Thank U Thank u so much
THANKS 😊 NICE EXPLANATION 👌 👍
Nice, please keep posting
Thank you!
Thanks!
This tutorial is really useful..
Thank you!
Thank you so much, this is a very good tutorial!
Congratulations!
Thank you! :)
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.
Really Appreciable, Much helpful 💕
Please do make more videos on Numpy and Pandas facing much errors in this
Thanks for the encouragement Anuj!
@@thefriendlycoder_ Most Welcome
You are fantastic thank you for video.
Thank you!!
Waiting for more videos.
Great video, thank you!
Thank you!
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.
+1 request - Please zoom in on codes, because it's difficult when they're so tiny.
Thanks for the feedback :)
You leave me no choice….”subscribed”
😂😂😂 thank you!
Wow great video!!!
That was good, thanks.
Hola Laura, tu video hizo que resuma mi codigo a de mas de 10 filas a 4. Saludos desde Perú. Gracias
Gracias! ☺️
This was very helpful - Thanks for putting this together. How would you format the cells?
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?
Liked your tutorial. Would like to do lookups from one sheet to another. That would be a great tutorial.
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
really helpful
thank you
Thank you!
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.
Hey, it's really great!!!
Really good tutorial !
How about if we want to compare data in dataframe before concatenate?
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
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.
Thanks, I will try ❤️
How can we convert each xlsx sheet as single csv to load to destination. Can you please explain this scenario
Thank you for this. Can I combine sheets into one if I’m dealing with more than 3million rows of data?
Hey Laura, This tutorial is very Helpful. Can you please do another video on how to combine cols by cols. thanks
Nice and pretty teacher.
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?
Thanks!! It helped me
That's awesome! Thanks for the feedback :)
Many thanks
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
Hi! For formatting (e.g, adding color, making text bold) I suggest using the library openpyxl instead of pandas.
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.
Why no more tutorials? This one was really helpful!
Thank you for this comment! I posted another video
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).
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?
Thanks, 👍👍👍
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
great job
Thank you!
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
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
Wow ,Thanks 😘🕊🙏🏻
Thank You
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?
How Laura can you please guide me how to fetch only current date excel files from specific time frame
Hello Laura , i have a doubt about combining different files to single files but in a different sheet
Is there any platform so i can post my query and you can help me with it
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
thans you very much
How to do it for csv files??????
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
Thanks!
Thank you!
Could I use Visual Studio, Instead of IDE?
Yes! Visual studio is a type of IDE
Great....
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?
Good idea thank you!
thank you
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.
Hi Randoms. Did you manage to find solution on this one. I am also trying to find solution on it.
@@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
@@alikhanak123 that is great. It looks like the exact same solution I am looking for. If you comfortable sharing the solution you have.
@@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.
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
it's fine what you're doing, but you need to set the font size up
I always get ValueError: Invalid file path or buffer object type:
thanks
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
Hey Saurabhdeep, does the code run before 6.45 for you?
How to convert csv files into one excel sheet in different tabs ? Please help
Do you still need help with your csv files?
@@umara941 Yes, please If you can.
@@shreya4676 okay, let's discuss it. Do you have email, discord or telegram that we can use to discuss it and share files?
May I know which software is this
Pycharm
Hum, interesting, Python is blazing fast to process all this stuff.
getting error as "ValueError: Excel file format cannot be determined, you must specify an engine manually."
Hey! Are all your excels closed?
@@thefriendlycoder_ yes, all are closer
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.
This code dosent work for xlsx format
Please help
Hey Ashay, until what part/minute does your code run?