40 Data Science Tips I Wish I Knew Sooner

📩 Interested in hearing about my coming courses? 👉 forms.gle/u4h9fLmbxjQHHScb9
📚 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

[@Thuvu5]

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

[@hassanlaqrabti4036]

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

[@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]

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]

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]

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

[@ts5778]

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]

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

[@philippe6724]

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

[@Arctect]

Thank you! Very useful and all in one place!

[@Dungo-yk9jj]

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

[@isalutfi]

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

[@Arthur_N_Rich]

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!

[@cerealport2726]

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

[@sandydsa]

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.

[@alexramos587]

Very helpful. Thank you.

[@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]

Thanks for the sub!! Really appreciate it 🙌

[@saidivya4789]

Thanks for this resourceful video 🤍

[@baotrancao206]

many thanks from Viet Nam

[@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]

Really appreciate this 🤩❤️

[@jaismeen5532]

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

[@sagarv8351]

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

[@delarammehrpouran8246]

It was amazing. Thanks a lot ❤

[@RobertHorvat93]

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

[@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]

Great to hear! 💖

[@GeorgeVMorpheus]

Very informative, so, thank you :)

[@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.

[@sankethujare5520]

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

[@nyashamagora7385]

my favorite channel

[@thankyouthankyou1172]

thank you!

[@user-bv3ci7pf2r]

holy moly you are vids are knowledge rich

[@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 :)

[@jcbritobr]

Nice stuff.

[@anabelberumen]

great video n.n

[@ANIRUDHVISVESVARAN]

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

[@Thuvu5]

Amazing! All the best to you! 🎉

[@ANIRUDHVISVESVARAN]

@@Thuvu5 thx sis

[@vinimagalhaes7115]

thank yoou!!

[@faisalgul6904]

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

[@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]

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

[@joaoguerreiro9403]

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

[@sunnyahmed5935]

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

[@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.

[@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.

[@amt.7rambo670]

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

[@franciscoletelier5598]

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

[@DAVIDNGUYEN-mp2kk]

❤

[@autobase16]

🎉🎉🎉🎉

[@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]

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

[@txreal2]

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

[@Thuvu5]

Absolutely 😂

[@keastontejada6069]

P R O M O S M

[@amt.7rambo670]

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

[@Thuvu5]

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

[@RC.-]

Jesus loves you so much.

[@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

[@beloaded3736]

Thank You ma'am 🌹

[@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]

Chị cám ơn em 🤩🥰

[@mohammednayaz1005]

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