Nice video!! Thanks for aways sharing your knowledge with us. Hugs from Brazil 💚. Alternative possibilite: with pandas you can manipulate Excel too.
@NeuralNine
3 жыл бұрын
Thanks brother! :)
@K59911
3 жыл бұрын
Hey man, nice video. I am always impresed how you always get your information to solve those problems. I study a mixture of economics and programming in germany. I already wrote little programms in different languages but i am still confused how to find the libaries i ned for my specific tasks and sadly it's more often than i like the case, that i don't know how to find the right things on stackoverflow, etc. Do you have any tipps especialy how to find and work with libaries for a medium entry beginner? Thanks a lot and go on with your nice work 💪
@yvanleroux88
3 жыл бұрын
Is it possible to launch a py script using a macro ? The idea is to be able to refresh / update cells without quitting the excel file every time
@CodingIsFun
3 жыл бұрын
Yes, you could use VBA for this: Sub RunPythonScript() Dim objShell As Object Dim PythonExePath as String, PythonScriptPath As String ActiveWorkbook.Save ChDir ActiveWorkbook.Path Set objShell = VBA.CreateObject("Wscript.Shell") 'PythonExePath = """ Insert Path to Python EXE here """ 'PythonScriptPath = """ Insert Path to Python SCRIPT here """ objShell.Run PythonExePath & PythonScriptPath End Sub
@yvanleroux88
2 жыл бұрын
@@CodingIsFun Thx a lot ! Appreciate that (:
@marcosoliveira8731
2 жыл бұрын
I´m using most shown here on my daily job. Well done! I´m working with a lot of big excel files, which takes a lot of time for the programs created the dataframes that are needed do process data. Is there a "fastest way" to create a dataframe from a excel file other than "pd.read_excel" that I normally use?
@Ayushsaxena-iz4rt
3 жыл бұрын
Hey it would be appreciated if you will make a tutorial on socket for beginners in python because i am struggling with the concepts of socket and i think you are best teacher Thanks in advance
@NeuralNine
3 жыл бұрын
Take a look at the channel. I have uploaded exactly the video you are looking for a couple of days ago.
@charan2446
3 жыл бұрын
Good video! can you make a playlist or videos on C++. Topics are same as what you did on python videos. Ex: convert this video, python into C++.
@garfield-pro
3 жыл бұрын
I created a folder named Misc in Windows 7, then I renamed it to Misc.. and it disappeared. Any idea where it went?
@subhankarchakraborty3866
3 жыл бұрын
U r too good brother😘😘😘😘
@ThePakfairy21
3 жыл бұрын
Can we automate likes on KZitem, so that we could automatically like all of your videos.
@NeuralNine
3 жыл бұрын
Give it a try ^^
@ThePakfairy21
3 жыл бұрын
@@NeuralNine I would love to but I am still a newbie in coding😅😅
@test555channel
3 жыл бұрын
How is this considered automation when you have to do x10 more steps for the same result.
@dishangmehta4397
3 жыл бұрын
Florian: Excel isn't a programming language. VBA: Am i a joke to you?!
@NeuralNine
3 жыл бұрын
VBA is a programming language. Excel isn't. But yes VBA is a joke to me.
@zombiekiller7101
3 жыл бұрын
Lol🤣
@dgh25
2 жыл бұрын
VBA has not been updated since 1997 (except for support for new Excel feautures). VBA lacks a lot behind when compared to modern programming languages, for example VBA cannot extend classes. The error handling is made by using labels, which makes "spaghetti" code. And so on. So yeah agree VBA is fun, but kinda also a joke. Even Microsoft is currently moving to Python as the default language behind Office. The founder of Python was hired by Microsoft in 2020. Also: VBA only works on Windows and Mac - no Linux. And using external refs and or ActiveX, makes it Windows specific. Not really what you want in a modern IT environment.
@tusam3643
3 жыл бұрын
hey man, yfinance package is now working for Yahoo finance, run a pip --update
@abhinavchoudhary6849
3 жыл бұрын
Noice
@NeuralNine
3 жыл бұрын
:)
@fus3n
3 жыл бұрын
Make a tutorial on developing brains!
@OmarHosam203
3 жыл бұрын
b.. buh... but im using linux
@NeuralNine
3 жыл бұрын
Well, Linux supports XLSX files as well ^^
@charan2446
3 жыл бұрын
Just use LibreOffice or OpenOffice. they both support Excel formats/
Пікірлер: 34