40 Data Science Tips I Wish I Knew Sooner

📩 Interested in hearing about my coming courses? 👉 forms.gle/u4h9fLmbxjQHHScb9
Receive top data science/ AI insights in your inbox 👉 thu-vu.ck.page/49c5ee08f6
📚 Glimpse into R data.table 👉 bookdown.org/brianjmpark/ever...
Hi everyone 👋! In this video I demonstrated 40 tips to help you become more proficient in day-to-day data science tools such as Jupyter notebooks, VS Code, Python, R and RStudio, and Excel! It's definitely the longest video I have ever made and took me tons of time, but hopefully it will give you some useful tips, no matter if you are a novice or a seasoned data analyst/ data scientist.
Thank you for watching and have a great day! 🤗
🔑 TIMESTAMPS
================================
Tips for Jupyter notebooks:
00:00 Intro
00:48 Jupyter Notebooks
00:50 - #1 Use JupyterLab/ VS Code (instead of Notebook)
2:44 - #2 Useful shortcuts in notebooks
7:44 - #3 Add an image to notebooks
8:36 - #4 Move around quickly
10:04 - #5 Multi-cursors
11:16 - #6 Code completion
11:41 - #7 Debugging in JupyterLab
19:45 - #8 Magics
23:07 - #9 Timeit magic
24:40 - #10 Writing formulas in notebook cells
Tips for Python:
25:46 - Python
25:58 - #11 Chaining comparisons
26:31 - #12 Using f-strings
27:32 - #13 List comprehensions
29:12 - #14 Creating Python virtual environments
30:47 - #15 Creating and using requirements.txt file
32:39 - #16 Python libraries for profiling reports
33:38 - #17 Highlighting pandas tables
35:17 - #18 Type hinting
Tips for Visual Studio Code:
37:14 - VS Code
37:30 - #19 Opening project folders VS Code
39:07 - #20 Using code completion VS Code
39:43 - #21 Useful shortcuts in VS Code
42:32 - #22 Running Python scripts interactively in VS Code
43:55 - #23 Debugging in VS Code
Tips for RStudio (sorry I accidentally had double #27 here 😅)
46:07 - RStudio
46:23 - #24 Shortcuts in RStudio
47:11 - #25 Find function definition in RStudio
48:48 - #26 Creating R projects
50:08 - #27 Debugging in RStudio
51:20 - #27 The most useful package in R 😉
52:31 - #28 Data profiling in R
54:16 - #29 Parallelizing code in R (doParallel package)
Tips for Excel:
59:16 - Excel
59:41 - #30 Customising status bar in Excel
1:00:24 - #31 Using Analyze Data tool in Excel
1:02:48 - #32 Using Excel table
1:05:24 - #33 Creating slicers for Excel reports
1:06:28 - #34 Keyboard shortcuts in Excel
1:07:48 - #35 Typing headers quickly in Excel
1:08:27 - #36 Doing statistical analyses in Excel
1:09:52 - #37 Filling blank values in Excel
1:10:43 - #38 Conditional formatting in Excel
1:12:00 - #39 Recording custom Excel macros
1:15:15 Conclusion
👩🏻‍💻 COURSES & RESOURCES
================================
📖 Google Advanced Data Analytics Certificate 👉 imp.i384100.net/anK9zZ
📖 Google Data Analytics Certificate 👉 imp.i384100.net/15v9y6
📖 Learn SQL Basics for Data Science Specialization 👉 imp.i384100.net/AovPnJ
📖 Excel Skills for Business 👉 coursera.pxf.io/doPaoy
📖 Machine Learning Specialization 👉 imp.i384100.net/RyjykN
📖 Data Visualization with Tableau Specialization 👉imp.i384100.net/n15XWR
📖 Deep Learning Specialization 👉 imp.i384100.net/zavBA0
📖 Mathematics for Machine Learning and Data Science Specialization 👉 imp.i384100.net/LXK0gj
📖 Applied Data Science with Python 👉 imp.i384100.net/gbxOqv
🙋🏻‍♀️ LET'S CONNECT!
================================
🤓 Join my Discord server: / discord
📩 Newsletter: thu-vu.ck.page/profile
✍ Medium: / vuthihienthu.ueb
🔗 All links: linktr.ee/thuvuanalytics
As a member of the Amazon and Coursera Affiliate Programs, I earn a commission from qualifying purchases on the links above. By using the links you help support this channel at no cost for you.
Edited with Gling: gling.ai
#python #datascience #productivity

Пікірлер: 71

  • @Thuvu5
    @Thuvu5 Жыл бұрын

    What is your favourite tip and trick using data science tools? Pls share it with me below! 😎

  • @hassanlaqrabti4036

    @hassanlaqrabti4036

    Жыл бұрын

    I hope you will put videos like this one and tutorials thanks for your effort

  • @theawesomeharris

    @theawesomeharris

    Жыл бұрын

    thanks for all your timestamps you so conveniently put inside the description :) will definitely come in handy when i revisit this video from time to time :D

  • @pondokmunzir3599

    @pondokmunzir3599

    Жыл бұрын

    hi Thu Vu , can you activate the translate feature into Indonesian. I am your subscriber from Indonesia. It looks like the auto translate feature to Indonesian doesn't work if you don't set it in your video settings. Thank You.

  • @LukeBarousse
    @LukeBarousse Жыл бұрын

    Magic commands in Jupyter Notebooks are so underrated!! I typically have my data in a BigQuery database and they have a magic command that I can easily write SQL to import the data into a pandas dataframe and then manipulate it. Such a game changer!

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Thanks for sharing this, Luke! I’ve never written SQL with magics before 😀

  • @waynesmith7410
    @waynesmith7410Ай бұрын

    Great tips!! Thank you

  • @Programmer_Bilal
    @Programmer_Bilal19 күн бұрын

    I'm on track to become a data scientist. This really hepled for sure. Thank you for making this video❤

  • @ts5778
    @ts57785 ай бұрын

    How does this not have more likes! Maybe you should make a separate series targeting newbies or people who want to polish up their skills as a professional. I like your videos because you are clear and concise. I've been introduced to so many new tools because of your channel.

  • @MB-cd7eo
    @MB-cd7eo Жыл бұрын

    Thank you. This information is not easy to find together. Very useful. All the best!

  • @Arctect
    @Arctect Жыл бұрын

    Thank you! Very useful and all in one place!

  • @first_rays9292
    @first_rays929222 күн бұрын

    Super valuable! Many thanks!

  • @isalutfi
    @isalutfi Жыл бұрын

    Thank you for this helpful content. Greetings from Indonesia 🇮🇩. Currently am learning data science.

  • @chomchom216
    @chomchom21621 күн бұрын

    Great tips. Thank you very much for sharing. 🙂

  • @sandydsa
    @sandydsa9 ай бұрын

    Any SQL tips? 😄 I can hope, right? Hahaha! Anyway, great great job on this video! I keep coming back to this video to ensure I don't, miss any tricks! The timestamps are perfect as well, so when I want to review topics I can go straight to them. I don't necessarily absorb everything at first, replaying your video helps with my learning curve. For 2023, you are one of my top subscriptions, including Luke Barousse, Alex the Analyst, Tina Huang and Data With Mo (Mo Chen). Somehow all of you exude positivity, you don't take yourselves too seriously, you are humble, or you all just smile a lot! Keep it up! We all need this atmosphere in the data community to erase that impression that we are "stuffy nerdy people" he he he.

  • @philippe6724
    @philippe67244 ай бұрын

    Extensive and well taught walkthrough of Jupyter lab! Thank you-)

  • @Dungo-yk9jj
    @Dungo-yk9jj Жыл бұрын

    Many thanks for your helpful tips. Your sharing is so admirable 😄

  • @cerealport2726
    @cerealport2726 Жыл бұрын

    Some excellent tips and tricks here that I didn't know before. Thanks very much!

  • @Arthur_N_Rich
    @Arthur_N_Rich11 ай бұрын

    I am here to say....thank you! This was a phenomenal video which was extremely helpful! Let us know when you're doing 1on1 mentorship sessions, I am ready to sign up!

  • @delarammehrpouran8246
    @delarammehrpouran8246 Жыл бұрын

    It was amazing. Thanks a lot ❤

  • @baotrancao206
    @baotrancao206 Жыл бұрын

    many thanks from Viet Nam

  • @landon2215
    @landon2215 Жыл бұрын

    Wow, jam packed with incredibly useful tricks! Instant subscribe. Can't wait for future videos :) Thank you so much for huge number of amazing tips to improve productivity and efficiency!

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Thanks for the sub!! Really appreciate it 🙌

  • @alexramos587
    @alexramos587 Жыл бұрын

    Very helpful. Thank you.

  • @sagarv8351
    @sagarv8351 Жыл бұрын

    It was really helpful. Thanks for sharing a knowledge to us. Keep posting a more content like this 🔥💥

  • @arjun6070
    @arjun6070 Жыл бұрын

    for python : pipreqs and for jupyter notebooks : pipreqsnb which create the requirements.txt for the only packages that we are using for the existing project instead of all packages in the environment.

  • @jaismeen5532
    @jaismeen5532 Жыл бұрын

    A very big thank tou for paving the way for us beginners..........💗💗💗

  • @saidivya4789
    @saidivya4789 Жыл бұрын

    Thanks for this resourceful video 🤍

  • @txreal2
    @txreal2 Жыл бұрын

    If you want to be productive, this is definitely a video you'll want to follow & bookmark. Subscribed Thu Vu DA for a while, learned a lot from her. Thanks for putting it all together 🙏🙏

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Really appreciate this 🤩❤️

  • @RobertHorvat93
    @RobertHorvat934 ай бұрын

    From now on you are my Data analytics auntie ! :D

  • @venkatprasath01
    @venkatprasath01 Жыл бұрын

    Great video 👏 Though I know few of the shortcuts already, It's nice to have a consolidate video which I can comeback and revisit anytime in future. Thanks again!! 😎

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Great to hear! 💖

  • @GeorgeVMorpheus
    @GeorgeVMorpheus Жыл бұрын

    Very informative, so, thank you :)

  • @sankethujare5520
    @sankethujare5520 Жыл бұрын

    Looking for more such vedios mama ..great work ..thank you

  • @yayitsmelody4948
    @yayitsmelody4948 Жыл бұрын

    I was missing your videos! I loooove your content and I'm currently taking your DS roadmap! thank you for that detailed plan and I also live in Amsterdam and was wondering if you could create a video about your thoughts of Data scientists basically disappearing in the upcoming years and how to prepare for that, also with some search in job engines to see if it truly disappearing or jobs for DS lowering (I bring the topic because of different O'reilly webinars with data scientists who mention it and I want to see your point of view since you also live here :) and I wonder if I can continue studying DS or will have to turn into DE which I feel I'm not so good in coding...) Thank you! would be amazing if you had a community here in the netherlands so we could all meet in person :)

  • @thankyouthankyou1172
    @thankyouthankyou1172 Жыл бұрын

    thank you!

  • @nyashamagora7385
    @nyashamagora7385 Жыл бұрын

    my favorite channel

  • @user-bv3ci7pf2r
    @user-bv3ci7pf2r7 ай бұрын

    holy moly you are vids are knowledge rich

  • @jcbritobr
    @jcbritobr Жыл бұрын

    Nice stuff.

  • @ANIRUDHVISVESVARAN
    @ANIRUDHVISVESVARAN Жыл бұрын

    Thx sister ... ❤ In few days I am going to start my course int Msc Data Science

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Amazing! All the best to you! 🎉

  • @ANIRUDHVISVESVARAN

    @ANIRUDHVISVESVARAN

    Жыл бұрын

    @@Thuvu5 thx sis

  • @anabelberumen
    @anabelberumen Жыл бұрын

    great video n.n

  • @vinimagalhaes7115
    @vinimagalhaes71155 ай бұрын

    thank yoou!!

  • @yash1152
    @yash1152 Жыл бұрын

    One tip for you 😉😜: put the following paragraph between the "🔑 TIMESTAMPS ================================" and "Tips for Jupyter notebooks:" in description: 00:00 Intro 00:48 Jupyter Notebooks 25:46 Python 37:14 VS Code 46:07 RStudio 59:16 Excel 1:15:15 Conclusion also, there's an offending dash in timestamp in this line: 1:10:-43 - #38 Conditional formatting in Excel

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Aw thank you so much for this! I've adjusted the timestamps according to your suggestions 🙌🏽

  • @joaoguerreiro9403
    @joaoguerreiro9403 Жыл бұрын

    Make videos applying Computer Science like nang channel does!! It would be great to see it :D

  • @terabaap5182
    @terabaap5182 Жыл бұрын

    Hello ma'am I am from india🗺️❤️ Your lecture are really helpful. I am currently studying economics*statistics I want to pursue my career in data analytics what should I do help me please.

  • @sunnyahmed5935
    @sunnyahmed5935 Жыл бұрын

    kindly make a review video on chatgpt code interpreter and its impact on data analytics job

  • @faisalgul6904
    @faisalgul6904 Жыл бұрын

    Thank you dear Can anyone recommend Msc Data Analytics/Business Analytics online studies ?

  • @franciscoletelier5598
    @franciscoletelier5598 Жыл бұрын

    # The best shortcut is Multi comment lines # for Mac: Command + shift + / (key 7) # saving your wrong code once again hahahah

  • @pondokmunzir3599
    @pondokmunzir3599 Жыл бұрын

    hi Thu Vu , can you activate the translate feature into Indonesian. I am your subscriber from Indonesia. It looks like the auto translate feature to Indonesian doesn't work if you don't set it in your video settings. Thank You.

  • @mjbah
    @mjbah Жыл бұрын

    Hi Thu Vu, thanks for the always useful and knowledgeable videos. The only thing I think is that your videos are usually a bit lengthy and can discourage someone from watching the entire video by skipping along which means you can miss important parts of the video. This particularly important video would have been excellent if it is at most 30 mins or less.

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Thanks for the tips! I'll keep it in mind :)

  • @amt.7rambo670
    @amt.7rambo670 Жыл бұрын

    I have one doubt. Is there a way to integrate Open Cv C++ code with react js ui???

  • @txreal2
    @txreal2 Жыл бұрын

    30 yo? looks like you aged some preparing for this video :) JK thanks for the action-packed tips for data analytics

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Absolutely 😂

  • @pepper_lab
    @pepper_lab Жыл бұрын

    🎉🎉🎉🎉

  • @DAVIDNGUYEN-mp2kk
    @DAVIDNGUYEN-mp2kk9 ай бұрын

  • @keastontejada6069
    @keastontejada6069 Жыл бұрын

    P R O M O S M

  • @amt.7rambo670
    @amt.7rambo670 Жыл бұрын

    Thu vu hair never grows 😂 its the same from when u got haircut.

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Haha I keep coming back to short hair because I feel like it looks better on me 🙈

  • @yash1152
    @yash1152 Жыл бұрын

    me on seeing ms-excel icon: GROSS in thumbnail & at 0:19 59:20 Excel - the _slaver_ of it all no bad feels for you Thuvu5, it's just i hate these Corps with their bloated gooey (goo-ey or GUI) mess. excel is a _massively_ mangled hotch potch of any work related with tables (& not just data tables) - it's tooooo generalised

  • @RC.-
    @RC.- Жыл бұрын

    Jesus loves you so much.

  • @beloaded3736
    @beloaded3736 Жыл бұрын

    Thank You ma'am 🌹

  • @p.u.t.a
    @p.u.t.a Жыл бұрын

    You put in way too much effort for this video. Thank you so much! Chúc chị Thư luôn xinh đẹp luôn thành công nhé

  • @Thuvu5

    @Thuvu5

    Жыл бұрын

    Chị cám ơn em 🤩🥰

  • @mohammednayaz1005
    @mohammednayaz100511 ай бұрын

    Would you be releasing videos on the DOMO BI App please?