Пікірлер
@shivkay
@shivkay Ай бұрын
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-s5q
@Oostenwald-s5q 2 ай бұрын
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_
@thefriendlycoder_ 2 ай бұрын
Thank you! Great idea
@joeytay5141
@joeytay5141 2 ай бұрын
Words too small😂
@gmagcaling
@gmagcaling 3 ай бұрын
Very helpful!
@thefriendlycoder_
@thefriendlycoder_ 2 ай бұрын
Thank you!
@breadb4meat
@breadb4meat 4 ай бұрын
you sound like a hot cheeto girl
@marioorozco3442
@marioorozco3442 4 ай бұрын
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_
@thefriendlycoder_ 3 ай бұрын
I actually don’t have an instagram but if I do in the future I’ll link it
@marioorozco3442
@marioorozco3442 3 ай бұрын
@@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.
@marioorozco3442
@marioorozco3442 4 ай бұрын
Hi Laura! Thanks for sharing
@thefriendlycoder_
@thefriendlycoder_ 3 ай бұрын
You are so welcome!
@enricomendiola9952
@enricomendiola9952 6 ай бұрын
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?
@ja1686
@ja1686 6 ай бұрын
Keep it up👍
@thefriendlycoder_
@thefriendlycoder_ 6 ай бұрын
Thank you!!!
@ja1686
@ja1686 6 ай бұрын
Very nice thanks
@thefriendlycoder_
@thefriendlycoder_ 6 ай бұрын
Thank you!!
@ja1686
@ja1686 6 ай бұрын
Thank you for this
@thefriendlycoder_
@thefriendlycoder_ 6 ай бұрын
No problem 😊
@deepakhaldar2983
@deepakhaldar2983 6 ай бұрын
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_
@thefriendlycoder_ 6 ай бұрын
Thank you! A great suggestion :)
@user-gt8qg7bd2q
@user-gt8qg7bd2q 6 ай бұрын
Great explanation style, thanks for your work!
@thefriendlycoder_
@thefriendlycoder_ 6 ай бұрын
Thanks!!
@user-gt8qg7bd2q
@user-gt8qg7bd2q 6 ай бұрын
Very helpful and easy to understand, Thanks
@thefriendlycoder_
@thefriendlycoder_ 6 ай бұрын
Thank you!! 😊
@user-gt8qg7bd2q
@user-gt8qg7bd2q 6 ай бұрын
Love this! I was finally able to understand, 🤍
@thefriendlycoder_
@thefriendlycoder_ 6 ай бұрын
Glad it helped!
@macrefinerymartinez1430
@macrefinerymartinez1430 7 ай бұрын
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?
@nasserabdal523
@nasserabdal523 7 ай бұрын
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_
@thefriendlycoder_ 7 ай бұрын
Hi! For formatting (e.g, adding color, making text bold) I suggest using the library openpyxl instead of pandas.
@nick-oi1xf
@nick-oi1xf 7 ай бұрын
I really enjoy your style of teaching. Thank you!😊
@thefriendlycoder_
@thefriendlycoder_ 7 ай бұрын
Thank you so much!!
@FaizanScribe
@FaizanScribe 7 ай бұрын
How can I get in touch with you ? I have a question thats too long to post here.
@PONCEJE
@PONCEJE 7 ай бұрын
You are fantastic thank you for video.
@thefriendlycoder_
@thefriendlycoder_ 7 ай бұрын
Thank you!!
@PONCEJE
@PONCEJE 7 ай бұрын
Waiting for more videos.
@jinit8083
@jinit8083 7 ай бұрын
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_
@thefriendlycoder_ 7 ай бұрын
This makes me so happy! thank you 😊
@luisagonzalez4102
@luisagonzalez4102 8 ай бұрын
I really needed this, thank you!
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you!! ✨
@johnericangat1016
@johnericangat1016 8 ай бұрын
So informative!
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you!!
@AzNFiR
@AzNFiR 8 ай бұрын
Awesome job
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you!!
@luisalbertolopezarias5042
@luisalbertolopezarias5042 8 ай бұрын
The Excel
@luisalbertolopezarias5042
@luisalbertolopezarias5042 8 ай бұрын
Yeeees
@jonelatendido9836
@jonelatendido9836 8 ай бұрын
Could I use Visual Studio, Instead of IDE?
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Yes! Visual studio is a type of IDE
@mariachica6913
@mariachica6913 8 ай бұрын
Very interesting, thank you!
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you!
@macrefinerymartinez1430
@macrefinerymartinez1430 8 ай бұрын
How do you read values from a spreadsheet that has formulas using read_excel?
@thefriendlycoder_
@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
@macrefinerymartinez1430
@macrefinerymartinez1430 7 ай бұрын
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_
@macrefinerymartinez1430
@macrefinerymartinez1430 7 ай бұрын
TNote: The company report has cells that are calculated by formulas. That is where I sometimes get the NaN instead of the value.
@cdisla98
@cdisla98 8 ай бұрын
Seriously so helpful! Thank you!
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you!! ❤
@miladghalehnoei8300
@miladghalehnoei8300 8 ай бұрын
thank you🙏🙏🙏
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thanks for watching!
@gloriachica986
@gloriachica986 8 ай бұрын
THANK THANK 🥰
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you for watching!
@gloriachica986
@gloriachica986 8 ай бұрын
Interesting interesting 🤔 👍
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you! 💛
@asamwill4076
@asamwill4076 8 ай бұрын
Thanks
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you!!
@tahmidurrabb8142
@tahmidurrabb8142 8 ай бұрын
Great tutorial! It was easy to follow 👍
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you so much!!
@LanceToledo
@LanceToledo 8 ай бұрын
This was super helpful and easy to understand!!
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you!!
@cdisla98
@cdisla98 8 ай бұрын
Thank you for this!! It will save me so much time at the office 😊
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you!
@luisagonzalez4102
@luisagonzalez4102 8 ай бұрын
I'm just starting to code, this was really helpful!!
@thefriendlycoder_
@thefriendlycoder_ 8 ай бұрын
Thank you!!
@mackensonreginaldmichel399
@mackensonreginaldmichel399 9 ай бұрын
Nice tuto
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you!!
@luisagonzalez4102
@luisagonzalez4102 9 ай бұрын
Great video, thank you for adding the notebook, it was extremely helpful!!
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you so much!!
@johnericangat1016
@johnericangat1016 9 ай бұрын
I always comeback to your comobine excel file video. Glad you came back. Looking forward on your videos.
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you so much! Will def be posting more
@BizzaroBrainBoi
@BizzaroBrainBoi 9 ай бұрын
You randomly showed up on my feed. Glad to add you and follow you. You super pretty too.
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you!
@mariachica6913
@mariachica6913 9 ай бұрын
Omg love this video, thanks ❤ That’s exactly I’m looking for
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you!!
@cdisla98
@cdisla98 9 ай бұрын
This is such a great video! It is precisely what I was looking for! Thank you!
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you!
@gloriachica986
@gloriachica986 9 ай бұрын
Thank you
@atangbingana283
@atangbingana283 Жыл бұрын
Hey did you give up ? keep going ✊❤
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you for the encouragement! I just posted another video!
@atangbingana283
@atangbingana283 9 ай бұрын
Thanks for coming out of retirement - time to build 👊🏽 @@thefriendlycoder_
@TajMikel
@TajMikel Жыл бұрын
Why no more tutorials? This one was really helpful!
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you for this comment! I posted another video
@robertreed4337
@robertreed4337 Жыл бұрын
excellent +++++++
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you!!
@call-me-potato.
@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_
@thefriendlycoder_ 9 ай бұрын
Thank you so much! Will take all of this into consideration.
@sravankumar1767
@sravankumar1767 Жыл бұрын
Do more videos 📹
@thefriendlycoder_
@thefriendlycoder_ 9 ай бұрын
Thank you! Just posted another
@sravankumar1767
@sravankumar1767 Жыл бұрын
How can we convert each xlsx sheet as single csv to load to destination. Can you please explain this scenario