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
@Oostenwald-s5q2 ай бұрын
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_2 ай бұрын
Thank you! Great idea
@joeytay51412 ай бұрын
Words too small😂
@gmagcaling3 ай бұрын
Very helpful!
@thefriendlycoder_2 ай бұрын
Thank you!
@breadb4meat4 ай бұрын
you sound like a hot cheeto girl
@marioorozco34424 ай бұрын
Sorry Laura, I forgot to ask if you’re on IG or would this be the best method to ask you for help or follow questions. Many thanks
@thefriendlycoder_3 ай бұрын
I actually don’t have an instagram but if I do in the future I’ll link it
@marioorozco34423 ай бұрын
@@thefriendlycoder_ hi there again… I’m really trying to learn more coding… do you teach etc or just through KZbin? You teach so well that is easy to follow.
@marioorozco34424 ай бұрын
Hi Laura! Thanks for sharing
@thefriendlycoder_3 ай бұрын
You are so welcome!
@enricomendiola99526 ай бұрын
Hello, I have a question. When exporting datafrom to excel . You did not specify the path on the filename. How did you know that it is under the Onedrive subdirectory?
@ja16866 ай бұрын
Keep it up👍
@thefriendlycoder_6 ай бұрын
Thank you!!!
@ja16866 ай бұрын
Very nice thanks
@thefriendlycoder_6 ай бұрын
Thank you!!
@ja16866 ай бұрын
Thank you for this
@thefriendlycoder_6 ай бұрын
No problem 😊
@deepakhaldar29836 ай бұрын
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_6 ай бұрын
Thank you! A great suggestion :)
@user-gt8qg7bd2q6 ай бұрын
Great explanation style, thanks for your work!
@thefriendlycoder_6 ай бұрын
Thanks!!
@user-gt8qg7bd2q6 ай бұрын
Very helpful and easy to understand, Thanks
@thefriendlycoder_6 ай бұрын
Thank you!! 😊
@user-gt8qg7bd2q6 ай бұрын
Love this! I was finally able to understand, 🤍
@thefriendlycoder_6 ай бұрын
Glad it helped!
@macrefinerymartinez14307 ай бұрын
Laura: Here is an interesting request for data cleanup. I generate a report in excel.xlsx that has a column with characters representing cost. When generated, sometimes the software enters an asterisk (*) at the end of some of the rows to correspond to a comment. I have not been able to remove the asterisks by using df.str.strip() or df.str.rstrip(). I am able to remove any character except for the asterisk. Any suggestions?
@nasserabdal5237 ай бұрын
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_7 ай бұрын
Hi! For formatting (e.g, adding color, making text bold) I suggest using the library openpyxl instead of pandas.
@nick-oi1xf7 ай бұрын
I really enjoy your style of teaching. Thank you!😊
@thefriendlycoder_7 ай бұрын
Thank you so much!!
@FaizanScribe7 ай бұрын
How can I get in touch with you ? I have a question thats too long to post here.
@PONCEJE7 ай бұрын
You are fantastic thank you for video.
@thefriendlycoder_7 ай бұрын
Thank you!!
@PONCEJE7 ай бұрын
Waiting for more videos.
@jinit80837 ай бұрын
Thank you a thousand times for such easy to follow content and instructions. I’m learning to code and my old brain needs simple instructions. Your video helped me easily import data. Looking forward to seeing more videos/content from your channel. Worth the subscription 😊
@thefriendlycoder_7 ай бұрын
This makes me so happy! thank you 😊
@luisagonzalez41028 ай бұрын
I really needed this, thank you!
@thefriendlycoder_8 ай бұрын
Thank you!! ✨
@johnericangat10168 ай бұрын
So informative!
@thefriendlycoder_8 ай бұрын
Thank you!!
@AzNFiR8 ай бұрын
Awesome job
@thefriendlycoder_8 ай бұрын
Thank you!!
@luisalbertolopezarias50428 ай бұрын
The Excel
@luisalbertolopezarias50428 ай бұрын
Yeeees
@jonelatendido98368 ай бұрын
Could I use Visual Studio, Instead of IDE?
@thefriendlycoder_8 ай бұрын
Yes! Visual studio is a type of IDE
@mariachica69138 ай бұрын
Very interesting, thank you!
@thefriendlycoder_8 ай бұрын
Thank you!
@macrefinerymartinez14308 ай бұрын
How do you read values from a spreadsheet that has formulas using read_excel?
@thefriendlycoder_8 ай бұрын
Hi! When using read_excel, the dataframe will contain the computed values of the formulas, not the actual formulas themselves. You may want to use another library such as openpyxl instead for this
@macrefinerymartinez14307 ай бұрын
Thanks. I import data from a company report and I will so,eimes run into NaN one the files is read. I will try again. I am glad you are back posting videos. @@thefriendlycoder_
@macrefinerymartinez14307 ай бұрын
TNote: The company report has cells that are calculated by formulas. That is where I sometimes get the NaN instead of the value.
@cdisla988 ай бұрын
Seriously so helpful! Thank you!
@thefriendlycoder_8 ай бұрын
Thank you!! ❤
@miladghalehnoei83008 ай бұрын
thank you🙏🙏🙏
@thefriendlycoder_8 ай бұрын
Thanks for watching!
@gloriachica9868 ай бұрын
THANK THANK 🥰
@thefriendlycoder_8 ай бұрын
Thank you for watching!
@gloriachica9868 ай бұрын
Interesting interesting 🤔 👍
@thefriendlycoder_8 ай бұрын
Thank you! 💛
@asamwill40768 ай бұрын
Thanks
@thefriendlycoder_8 ай бұрын
Thank you!!
@tahmidurrabb81428 ай бұрын
Great tutorial! It was easy to follow 👍
@thefriendlycoder_8 ай бұрын
Thank you so much!!
@LanceToledo8 ай бұрын
This was super helpful and easy to understand!!
@thefriendlycoder_8 ай бұрын
Thank you!!
@cdisla988 ай бұрын
Thank you for this!! It will save me so much time at the office 😊
@thefriendlycoder_8 ай бұрын
Thank you!
@luisagonzalez41028 ай бұрын
I'm just starting to code, this was really helpful!!
@thefriendlycoder_8 ай бұрын
Thank you!!
@mackensonreginaldmichel3999 ай бұрын
Nice tuto
@thefriendlycoder_9 ай бұрын
Thank you!!
@luisagonzalez41029 ай бұрын
Great video, thank you for adding the notebook, it was extremely helpful!!
@thefriendlycoder_9 ай бұрын
Thank you so much!!
@johnericangat10169 ай бұрын
I always comeback to your comobine excel file video. Glad you came back. Looking forward on your videos.
@thefriendlycoder_9 ай бұрын
Thank you so much! Will def be posting more
@BizzaroBrainBoi9 ай бұрын
You randomly showed up on my feed. Glad to add you and follow you. You super pretty too.
@thefriendlycoder_9 ай бұрын
Thank you!
@mariachica69139 ай бұрын
Omg love this video, thanks ❤ That’s exactly I’m looking for
@thefriendlycoder_9 ай бұрын
Thank you!!
@cdisla989 ай бұрын
This is such a great video! It is precisely what I was looking for! Thank you!
@thefriendlycoder_9 ай бұрын
Thank you!
@gloriachica9869 ай бұрын
Thank you
@atangbingana283 Жыл бұрын
Hey did you give up ? keep going ✊❤
@thefriendlycoder_9 ай бұрын
Thank you for the encouragement! I just posted another video!
@atangbingana2839 ай бұрын
Thanks for coming out of retirement - time to build 👊🏽 @@thefriendlycoder_
@TajMikel Жыл бұрын
Why no more tutorials? This one was really helpful!
@thefriendlycoder_9 ай бұрын
Thank you for this comment! I posted another video
@robertreed4337 Жыл бұрын
excellent +++++++
@thefriendlycoder_9 ай бұрын
Thank you!!
@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_9 ай бұрын
Thank you so much! Will take all of this into consideration.
@sravankumar1767 Жыл бұрын
Do more videos 📹
@thefriendlycoder_9 ай бұрын
Thank you! Just posted another
@sravankumar1767 Жыл бұрын
How can we convert each xlsx sheet as single csv to load to destination. Can you please explain this scenario