- 32
- 252 964
Data Nik
Switzerland
Приєднався 15 січ 2020
I am a professional Data Scientist with about 2 years of experience. Through my videos I would like to give some educational content that hopefully helps you develop as a Data Scientist as well!
I hope you'll enjoy the content and stay for further updates :)
I hope you'll enjoy the content and stay for further updates :)
Side Bar Menu in Dash Plotly || Python Tutorial
In this video I am showing you how to easily create a side bar menu in the Dash Plotly library so that you can increase the usability of your Python dashboards.
Переглядів: 1 382
Відео
Dash Plotly Dockerisation URL Problem
Переглядів 165Рік тому
In this video I am going to show how to avoid a URL error when containerising Dash Plotly Projects with Docker. #coding #docker #python
Create your first Dashboard in Python | Data Science Project Part 3
Переглядів 187Рік тому
In this video we are going to create our first little dashboard in Python. The library we are going to use for this is called Dash Plotly. You can read up on the documentation here: dash.plotly.com/. I hope you enjoy this video!
How to start with GIT and PyCharm | Data Science Project Part 2
Переглядів 189Рік тому
In this video I am going over creating a project in PyCharm as well as how to add such project to GitHub. To follow this video you will have to have PyCharm installed which is explained here: www.jetbrains.com/help/pycharm/installation-guide.html I hope you enjoy!
A Full Data Science Project in Python | Data Science Project Part 1
Переглядів 208Рік тому
With this video I am going to introduce you to my latest multi-part video series on how to do Data Science projects in Python. We are going to talk about everything you need in order to start your own project. From Structuring a project in Python to the libraries we use, Git and GitHub, as well as deployment to Google Cloud. I hope you will enjoy this one!
Create a Graph in Python - Beginner's Tutorial
Переглядів 9 тис.3 роки тому
In this video I am going to show you how you can create in Python with Matplotlib and Pandas. This tutorial is meant for beginners.
Data Analysis for Beginners // Excel Tutorial
Переглядів 3443 роки тому
In this video I am going over a simple data analysis example. The data can be downloaded here: www.kaggle.com/carrie1/ecommerce-data
How to Use Vlookup in Excel
Переглядів 933 роки тому
In this video I am going to show you how to use the Vlookup function and what small traps to avoid when using it! I hope it helps.
Run Macro If Cell Value Changes / Excel VBA Tutorial
Переглядів 18 тис.3 роки тому
In this video, I am showing you how to run a VBA macro whenever the value within a specific cell changes. I hope this helps!
Delete Rows based on Value/Text // Excel VBA Tutorial
Переглядів 21 тис.3 роки тому
In this video I am showing you how to delete rows based on value or text. The code is the following: Sub delete_rows() For i = 2 To Sheets(2).UsedRange.Rows.Count If Cells(i, 3).Value = "No" Then Rows(i).EntireRow.Delete End If If Cells(i, 3).Value = "No" Then Rows(i).EntireRow.Delete End If Next i End Sub
Every Way to Access Cells // Excel VBA Tutorial
Переглядів 3713 роки тому
If you liked the video, please consider supporting the channel
Dice Throw in Excel VBA
Переглядів 1,2 тис.3 роки тому
In this video, I am going to show you how to simulate a dice throw in Excel using VBA coding. I hope this helps.
For Loops in VBA // Excel Tutorial
Переглядів 2033 роки тому
In this video I am showing you how to get along with For Loops in VBA.
Calculating CORRELATIONS in EXCEL
Переглядів 1633 роки тому
In this video I am showing you how to do a correlation analysis in Excel. For this you are going to need the "=Correl" formula. I hope this video helps!
IF Statement in VBA // VBA Basics
Переглядів 1893 роки тому
In this week's video, I am showing you how to use and apply the conditional statements if, elseif, and else in VBA to color a cell based on the value within. Feel free to leave a like or sub if this helped you, I would greatly appreciate it!
Update Data in Excel Automatically // VBA TUTORIAL
Переглядів 29 тис.3 роки тому
Update Data in Excel Automatically // VBA TUTORIAL
Import Stock Data into Excel // NEW EXCEL UPDATE 2020
Переглядів 2,2 тис.4 роки тому
Import Stock Data into Excel // NEW EXCEL UPDATE 2020
Drop Down Menu with adjusting Graph // Excel Tutorial
Переглядів 1764 роки тому
Drop Down Menu with adjusting Graph // Excel Tutorial
Straddle Option Calculated and Explained
Переглядів 2834 роки тому
Straddle Option Calculated and Explained
Importing External Data into Excel using Python
Переглядів 4,6 тис.4 роки тому
Importing External Data into Excel using Python
Adding Moving Averages to an Excel Graph
Переглядів 5544 роки тому
Adding Moving Averages to an Excel Graph
Hi Nik, a great video, thank you. Is there a way to delete rows which is empty but the cells have formulas. Thank you
Dibbert Fords
Thank you so much!!!
thank you.
You explained each step so well, and I really love your "no hard code" idea!!! Thank you for such a effective tutorial💯🎆
great explanation, thank you
Thanks!
Why do I choose data in the IQY format in Excel, data like in the video at minute 3:06? Cannot be selected.
when I save the document on word I use the scroll down window and hit .txt but there is no where to delete the .txt and put .iqy. It only lets me change the name. Can someone please help?
What is the size of your desktop 🤔
plzzz can you do it again with current version
My question is can I do this with any site? Or there needs to be a specific API key somewhere in the website?...I want to take data from the JSE stock exchange so I can build a project around ir
Most sites have an index or directory you can stumble across. I always find them at the weirdest but helpful times
is it possible to change color on smartart as well thru vba? thanks
Hi I'm trying to automate the publish and refreshing action buttons in team ribbon, can you suggest the macro for this..?
Finally found the video I need but I can't see a single thing you're doing 😫😫. Very unfortunate.
I get you point, but you could try pinching your fingers to zoom in if you are watching the video on a smaller device. Typically also works with the UA-cam app. Hope this helps!
Using MS Office 365 for Mac. Followed all your steps and the macro did not trigger. Macro is part of a module and the cell change event trigger is under the sheet where the cell value changes. The macro runs with no problem when manually triggered, but it seems like excel does not recognise the cell value change. Ideas? Thanks!
sir the font is si small nearly invisible pl enlarge whic could easily be watched dont mind sir
Kia Ora! Thanks for a very helpful video. How would you edit the code to delete cell that have a value after a particular date? Eg. delete dates after 11/06/2101 (dd/mm/yyyy) from a data set
What's wrong, it won't delete the rows in column A with the words Date in them. Nothing happens actually. Sub DeleteRowswithTextDate() For i = 1 To ActiveSheet.UsedRange.Rows.Count If Cells(i, 1).Value = "Date" Then Rows(i).EntireRow.Delete End If Next i End Sub
thank you! i found this helpful
Good video man but your keyboard is loud asf
Need help with macros because my data range always change sometimes its 1000 rows/coloums or somtime its more than that or sometime less
Hey, could you give me a little more detail about what you are trying to do?
Nice vid, i've been trying to find a easy solution and here it is. if you are having the same problem that excel wont recognize it as a iqy just do this (This is an extract of someone else comments) : ""Find the file that you saved with the .igy extension. Right click it and select 'Get Info'. Navigate to the 'Name and Extension' tab and I suspect that you have to delete the '.txt' suffix. Once you do, the OS will ask you what sort of file type you want to save the file as--.txt or .iqy. Select '.iqy'.""
that is cool, simple but useful, powerful...
Thanks
Hi Thank you for the video - it was very helpful. I have a question - is there a way to do the same for text file (.txt extension) search 1st word (text) and search 2nd word (text) and in between the range want to remove and save the file - PLEASE advise! Thank you for your help! - Dalpat
Hi Dalpat, Thanks for leaving a comment! As far as I know, though, Excel is not the place to be when trying to edit text files. However, you can also use VBA in Microsoft Word. It works a little bit different here, but you do also have something like a range function. Try this: Sub RemoveTextBetweenWords() Dim filePath As String Dim inputFile As String Dim outputFile As String Dim fileContents As String Dim firstWord As String Dim secondWord As String ' Set the file path and names filePath = "C:\Path\To\Your\File\" ' Change this to your file's directory inputFile = "input.txt" outputFile = "output.txt" ' Set the words to search for firstWord = "FirstWord" secondWord = "SecondWord" ' Read the contents of the input file Open filePath & inputFile For Input As #1 fileContents = Input$(LOF(1), #1) Close #1 ' Find the positions of the first and second words Dim firstPos As Long Dim secondPos As Long firstPos = InStr(1, fileContents, firstWord, vbTextCompare) secondPos = InStr(firstPos, fileContents, secondWord, vbTextCompare) ' Check if both words were found If firstPos > 0 And secondPos > 0 Then ' Extract the text before the first word Dim newText As String newText = Left(fileContents, firstPos - 1) ' Append the text after the second word newText = newText & Mid(fileContents, secondPos + Len(secondWord)) ' Save the modified content to the output file Open filePath & outputFile For Output As #2 Print #2, newText Close #2 MsgBox "Text between '" & firstWord & "' and '" & secondWord & "' has been removed." Else MsgBox "Either '" & firstWord & "' or '" & secondWord & "' not found in the file." End If End Sub
@@FinanceNik Thank you Data Nik for prompt response. Perfect! I used the idea and works perfectly fine for me. Appreciate it so much for your tips/help/Time/Efforts....Have a great day...
QQ: what if user wants to select Input File by themselves? and after extracting the text save same file but different folder. Any tips Please.
Hi Nik, I am removing lines between 2 searched text string, works perfectly fine but I have these searched string repeated many times, I removed with your suggestion 1 or 2 times but when it went to last search, vba errored out string not found, How do i resoled... i used Do while loop but not working, please advise! thank you for your time!
Thank you very much, it helps a lot
Hallo Sir, i have excel data come from scanning Barcode that content HTTPS link. Now i klik every single line of data to insert Barcode content to Google Form. All data at A colom. How to automate it when new line data come. Thks
Hey Edward, so what you could do it write a little script that always finds the last populated row in your excel sheet. Then, when you want to add data to that sheet you just insert it one line below the last populated line. Cheers
Good day. Thanks for this excellent site where I can get meaningful solutions. However, when I type the routine that call the macro, exactly like in the example, except for variables, I get an error on the following line: If Not Intersect(target.Range("O2")) Is Nothing Then Here is the error message: Compile Error: Argument not optional
Perfect Tutorial, thanks so much!
Perfect!!!
This was super useful, thank you!
Thank you man, it was super helpful!
Please, keep making these videos! I like the way you explain things!
you could just do a find on the date rather than splitting, but thank you!!!
true that! Thank you!
Hey thanks man. I got stuck where I couldnt import some matplotlib, little bit of googling showed me the commands to run. This was a big help, Im suprised your channel isnt larger, Have a great one
good.
Thx
Very useful, thanks
I also make video on similar subject
little fyi you have to install requests with sudo pip3 install requests
True! Thank you!
❤️🔥👍
This didn’t help 🥴
Hey Juan, can you explain why it did not work for you?
Hi ) amazing work! Can you make please a video about counting cells by color using Vba or some formula =countIF(A1:A100,”red”) thanks 😊
Hey POklav, thank you for the kind words! I'll write down your request!
nice one! Keep it going!
Thank you Max!
Please do more videos
Hey Albright, thank you very much for your encouraging comment! I am coming back this week!
You are an amazing teacher
Is it possible only the some rows rather than entire row.. Expecting reply
Heiii, thanl you for that!
Perfect the “messing link”
can you make a video in which one column data continuous change by time , that record we can and also time column changes according to that 2 column we can make automatically 5 min frame data in different row as open high low close that we can use in stock market
good vide. I was able to follow. Nice
Hi, I am getting type mismatch error when I try to include OR so that I can search and delete multiple names