![VitoshAcademy](/img/default-banner.jpg)
- Видео 94
- Просмотров 115 890
VitoshAcademy
Болгария
Добавлен 24 июл 2013
Welcome to the official Vitosh Academy channel! 🎓✨
Dive into the world of live coding and explore a variety of programming languages with us. Whether you're interested in VBA, C#, or Python, you'll find something valuable here.
Check out our website for more resources and tutorials: vitoshacademy.com!
Dive into the world of live coding and explore a variety of programming languages with us. Whether you're interested in VBA, C#, or Python, you'll find something valuable here.
Check out our website for more resources and tutorials: vitoshacademy.com!
Python - Understanding Standard Deviation
📊 Understanding Standard Deviation with Python: A Step-by-Step Guide 📊
Hey everyone!
Welcome to my channel! In this video, we're diving into the concept of standard deviation and how to calculate it using Python. Whether you're a beginner in statistics or looking to brush up on your data analysis skills, this video is for you! 🌟
🔍 What You'll Learn:
🤔 What is standard deviation? - 0:05
📝 Step-by-step manual calculation - 3:45
🐍 Practical Python coding examples - 11:38
🌍 Real-world applications of standard deviation - 14:20
GitHub repository with both jupyter labs here:
github.com/Vitosh/Python_personal/tree/master/RUclips/015_Python-Understanding-StDev
VitoshAcademy Article:
www.vitoshacademy.com/...
Hey everyone!
Welcome to my channel! In this video, we're diving into the concept of standard deviation and how to calculate it using Python. Whether you're a beginner in statistics or looking to brush up on your data analysis skills, this video is for you! 🌟
🔍 What You'll Learn:
🤔 What is standard deviation? - 0:05
📝 Step-by-step manual calculation - 3:45
🐍 Practical Python coding examples - 11:38
🌍 Real-world applications of standard deviation - 14:20
GitHub repository with both jupyter labs here:
github.com/Vitosh/Python_personal/tree/master/RUclips/015_Python-Understanding-StDev
VitoshAcademy Article:
www.vitoshacademy.com/...
Просмотров: 426
Видео
Python - Central Limit Theorem
Просмотров 10114 дней назад
Hey there! 👋 Welcome to the channel! 🌟 In this video, I am showing the way a central limit theorem works with jupyter lab and python! Let me know whether you prefer these type of a bit more scientifically oriented videos more ✨ Simple explanation of the "Central Limit Theorem": It states that the distribution of the sample means (averages) of a large number of samples from any population will b...
Excel - How to filter a pivot table based on a cell value?
Просмотров 21021 день назад
Hey there! 👋 Welcome to the channel! 🌟 In this video, I am showing how to filter an #excel pivot table, based on a cell value.✨ Pretty much, there are 3 methods: - with adding an additional boolean column to the source - with slicer and manually selecting the values - VBA (not shown in this video) I hope you enjoy the videos in my channel. 💚 Let me know if you find these interesting. 🔧 Thanks f...
Python - Pandas Cheat Sheet And More Helpful Tricks
Просмотров 176Месяц назад
Hey there! 👋 Welcome to the channel! 🌟 In this video I will mainly take a look at one pandas cheatsheet and will code a some of the tricks into a jupyter lab document. 🔗 Kaggle dataset: www.kaggle.com/datasets/rabieelkharoua/students-performance-dataset/data 🔗 Cheatsheet: pandas.pydata.org/Pandas_Cheat_Sheet.pdf 🔗 Jupyter lab code: github.com/Vitosh/Python_personal/tree/master/RUclips/013_Panda...
Dates in Excel and VBA. Functions with dates
Просмотров 1202 месяца назад
Hey there! 👋 Welcome to the channel! 🌟 In this video, I am showing the basics of the date system in Excel and in VBA. ✨ 🔗 Blog articles, related to the video: www.vitoshacademy.com/the-dates-in-excel-vba-and-sql-server/ www.vitoshacademy.com/vba-what-day-is-friday-in-the-week-of-a-given-date/ 📝Contents: Dates in Excel and VBA - 0:40 Dates in SQL Server, Excel.Date1904 - 3:35 29. February 1900 i...
Object Oriented Programming with Python
Просмотров 562 месяца назад
Hey there! 👋 Welcome to the channel! 🌟 In this video, I'll show you the basics of working with functions in Python. 🐍 🔗 Code repository: github.com/Vitosh/Python_personal/tree/master/RUclips/012_OOP-In-Python 📝Contents: Classes - 0:42 Methods - 2:48 Special methods - 6:08 Operator overloading - 13:30 Class methods - 15:20 Inheritance and abstract classes - 17:49 ✨The book, from which most of th...
Python - Working with Functions
Просмотров 232 месяца назад
Hey there! 👋 Welcome to the channel! 🌟 In this video, I'll show you the basics of working with functions in Python. 🐍 🔗 Code repository: github.com/Vitosh/Python_personal/tree/master/RUclips/011_Working_with_functions_Python 📝Contents: Giving functions more input - 1:50 Keyword arguments - 5:02 Functions as data - 8:30 Lambdas: Anonymous functions: 13:04 Applying functions to NumPy arrays 16:36...
Python - Plotting Data with Matplotlib
Просмотров 1442 месяца назад
Hey there! 👋 Welcome to the channel! 🌟 In this video, I'll show you the basics of using Matplotlib for plotting data with Python. 📊 🔗 Code repository: github.com/Vitosh/Python_personal/blob/master/RUclips/010_Plotting_data_with_Matplotlib/Matplotlib-Examples.ipynb 📝Contents: Making a scatter plot - 0:59 Making a line chart - 5:02 More lot cusomizations 11:19 ✨The book, from which most of the co...
Nice Excel Pivot. With slicers.
Просмотров 603 месяца назад
📊 Making a pivot in Excel is easier than you think! 🚀 In this video, I'll show you how to create an Excel pivot table with slicers, making your data analysis smoother and more dynamic. 🌟 👨🏫 What you'll learn: Step-by-step guide to creating pivot tables 📝 How to add and use slicers effectively 🔍 Tips to enhance your data analysis skills 📈 The data used in this tutorial comes from Kaggle, featur...
MS Word - Create Table of Contents Automatically
Просмотров 743 месяца назад
In just 7 minutes ⏱️, we'll walk you through the step-by-step process of creating a Table of Contents that will impress your readers and make navigating your document a breeze. Actually, the update of the table of content is quite straight forward, there are just two tricks: 1. Format the Headings, that you want to see in the table.📑 2. Click "References", "Table of Contents" in Word. ✨ 3. Upda...
Dot Product in 2D - briefly explained with Python
Просмотров 483 месяца назад
Hey there! 👋 Welcome to the channel! In this video we are taking a brief glance of dot product in linear algebra. That's why the video is about 10 minutes and we only take a look at the following case quickly: - vectors with dot product of 0 - vectors with dot product of 1 or -1 - vectors with other dot products The article for the video is here: 🖥️ www.vitoshacademy.com/linear-algebra-drawing-...
VBA - Creating Excel Range from VBA Array. With hidden rows.
Просмотров 2254 месяца назад
Welcome back to the channel! 🎉 In our previous video ruclips.net/video/cGKUdKCSQxk/видео.html, we delved into arrays and ranges in VBA, addressing common challenges and solutions. Following up on that discussion, we received a thoughtful question about handling invisible rows due to filtering within an Excel table. This video actually shows how to target this problem. Article and code here: www...
Linear Algebra - Drawing With Vectors - 3d 2d
Просмотров 1255 месяцев назад
Hey there! 👋 Welcome to the channel! 🚀 Ever wondering why do you need an identity matrix and what can you do with it? In this video for LA (Not the city) I am trying to explain what you can do with vectors and drawing them correctly in both 3D and 2D space, moving the vectors and the shapes they form with just a simple calculation with the identity matrix. The article for the video is here: 🖥️ ...
VBA - Creating an Array from Excel Range
Просмотров 1,1 тыс.6 месяцев назад
Hey there! 👋 Welcome to the channel! In this video, we're explore a tiny bit of the world of Visual Basic for Applications (VBA), showing quickly how to make an array from an Excel Range. 🚀 Another video for range to array, explaining in more details how to get the correct dimensions of the range: 🎬 ruclips.net/video/9zzY7qLu92U/видео.htmlsi=0JokKbszvtsZ-xLA The article with the code is here: 🖥...
Simplifying Excel Tasks with Python: Data Handling and Testing Tutorial
Просмотров 726 месяцев назад
📝 Description: Dive into the world of Excel automation with this hands-on Python tutorial! Perfect for beginners and seasoned professionals alike, this video provides a straightforward approach to managing Excel files using Python. We'll guide you through reading, manipulating, and writing data in Excel files, and show you how to incorporate dynamic Excel formulas using Python libraries like pa...
Python - API With Flask - Update and Delete
Просмотров 937 месяцев назад
Python - API With Flask - Update and Delete
Python - API With Flask - Create and Read from dummy DB
Просмотров 1427 месяцев назад
Python - API With Flask - Create and Read from dummy DB
Python - Simple API With Flask And Postman
Просмотров 3777 месяцев назад
Python - Simple API With Flask And Postman
Python - Removing Empty Spaces and None from pandas dataframes
Просмотров 998 месяцев назад
Python - Removing Empty Spaces and None from pandas dataframes
Python - OOP - Classes, Methods, Attributes, Composition, Inheritance
Просмотров 708 месяцев назад
Python - OOP - Classes, Methods, Attributes, Composition, Inheritance
Excel Floating Point Arithmetics is Wrong! Calculations to prove it!
Просмотров 1159 месяцев назад
Excel Floating Point Arithmetics is Wrong! Calculations to prove it!
Python In Excel. Displaying DataFrames in Excel.
Просмотров 8810 месяцев назад
Python In Excel. Displaying DataFrames in Excel.
Python In Excel. Shortcuts. Functions. Classes.
Просмотров 12410 месяцев назад
Python In Excel. Shortcuts. Functions. Classes.
Python - Logging. With a simple example.
Просмотров 8410 месяцев назад
Python - Logging. With a simple example.
Empty List as Default Argument in a Python Function
Просмотров 10211 месяцев назад
Empty List as Default Argument in a Python Function
How to use that array? Vba throws compile error
Hello, and thank you for your question.😊 If you are using the code from the article, then try these steps to avoid the compiling error: 1. Delete `Option Explicit ` 2. Make sure that you are having a worksheet named `Sheet1` 3. Put the code in a module. I am away from the keyboard right now, but if the compiling error still exists, try asking in Stackoverflow.com about it, if you tag the question with #Excel and #vba, and provide the code, and explain where is the compiling error, someone will probably answer in less than 1 hour. The #vba community there is helpful. Enjoy your day😊
nice video but for brevitys sake I would love to see timestamps or better editing since it took me quite some time to find the code example I needed. Keep up the good work tho
Thanks for the nice words :) Actually there are some timestamps in the contents. Or do you mean somethign else?
Thanks for covering this topic. As I see, there is no such fast solution for Array to range as it is for from range to Array....
🙂In general, I am not the ultimate "knowledge tank" of VBA, there could be a few solutions I am not aware of, but in theory you can easily build a `Sub` that gets an array and based of its dimensions it puts it into a range. Anyway, there are a few decisions you should make - if it is 1D array, how are you going to paste it? (As a column or as a row) What would you do with 3D arrays? Return error, or just write the first 2 dimensions and forget about the rest?
Thanks for the video! One issue - range to array is clear. But array to range is tricky. As long as no row or column is hidden, it works fine. But if there is something hidden (eg due to a filter) it does not work as expected. Any workarounds here?
Thanks for the question! Actually, I have thought of some possible solution for that problem and it might be a working one, if the array is a smaller one. If it is big, then it probably will work as well, but more time would be needed for the loop. I have made a video here, for the solution - - ruclips.net/video/9zzY7qLu92U/видео.html. Enjoy it!
I have products model, which constist of id,name, costprice,sale and I want make a trasncation where i can include any number of products and their quanity also i want incude transcation type like "In" or "out" using this I want update stocks model consists of product INstock. Please help
Nice.
Quite useful actually. Thanks for sharing your knowledge
Glad it was helpful!
@@b99eu You mistakenly posted your question to me and not the author.
This update is such a pain in the az
thanks. gute arbeit.
a confused lesson
Works like magic! Big thank you!
Do you have a place where I can learn complex model types? eg public Department Department {get; set;} any references is highly appreciated.
Hi! Thanks for reaching out! Any question in StackOverflow with 100+ reputation (as a sum of all answers and the question) is really worthy, so you can start from there: - stackoverflow.com/questions/37806159/what-is-a-complex-type-in-entity-framework-and-when-to-use-it Then, take a look at the referred links, as these are also worthy: - martinfowler.com/bliki/ValueObject.html - weblogs.asp.net/manavi/associations-in-ef-4-1-code-first-part-2-complex-types - learn.microsoft.com/en-us/previous-versions/dotnet/netframework-4.0/cc716799(v=vs.100)?redirectedfrom=MSDN In general, Microsoft is not a bad option for learning as well: - learn.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/creating-a-more-complex-data-model-for-an-asp-net-mvc-application That's all. Enjoy the learning experience🙂
@@vitoshacademy Thanks so much Vitoshacademy! Definitely will enjoy.
okay this is awsome .... as a noob i can?t do vba but i know pyhton :) really helpful
Great
WOW! Thank you!
Welcome :)
This no longer works. The drawing canvas option is no longer present in MS 2011
What is MS 2011?
Microsoft 2011 version. tx@@vitoshacademy
Do not have that version installed, sorry. (but I guess you found a workaround after 5 months)
Hi
is it possible to do that without drawing a new canvas?
Thank you so much!! I am only 10 mins into this video and it is one of the best I have seen and you do a great job with your explanations!
i can't see .net standard in create new project, where is problem ?
Hi, thanks for the comment. Which visual studio are you using? It can be based on that, is it the same I am using? I guess it is either this or you are missing some library or anything similar. stackoverflow.com/questions/64315213/visual-studio-2019-doesnt-show-me-net-standard-2-1-and-net-core-3-1-as-part-o
Hey, bro, try to make your presentations more agile. Why not explain in the beginning why would someone nest a dictionary?
how transform content in dataframe?
Hi please I dont understand the include and then include part and I wanna know how to retrieve the ID of the row to use it thanks
Hi! Take a look at this topic stackoverflow.com/questions/8742581/mutilevel-include-in-c-sharp-linq, and if you still do not understand it, try to write a question in Stackoverflow.com. Make sure to put the code that does not work, while trying to retrieve the ID, the people there will definitely help you, if you put some 10-20 lines of relevant code and describe your question well. 😉
But I am.facing authentication required error.. Why..?
No idea, it works for me. It could be that you are trying to access the pdf through a proxy or something. Here it says so - github.com/chrismattmann/tika-python/issues/158 Try to access a PDF file, which is based in the country where you are based (or your proxy).
Excellent work! Thank you!!!
Thanks for the nice words 🙂
paginatedList 25:15
I guess this is a bookmark for you?
Thank you so much. I knew it was possible, just wasn't sure how.
Well, it took me some time to find it out myself, so I decided to make a video. Btw, do you have any ideas about VBA/Python videos?
somewhere towards the beginning you got rid of the nav bar, how would you get that back?
I am a bit away from keyboard now, but if I believe stackoverflow.com, then either "tools>options>text editor>language" or simply rebuild. stackoverflow.com/questions/9131507/navigation-bar-gone-since-vs-11-install
Thanks!!
Thanks for the video bro!
Please use zoom in video,
Hi Singh, using zoom will be a good idea, but I doubt I will be able to make it for my next videos. Enjoy your day🙂
Thank you for all your content!😀
Thank you for taking the time to do this. You helped me learn not to get intimidated by errors no matter how long it takes to research them.
Thanks 😊 I really enjoy reading positive comments 😀
hi ask, sorry my English, why at time 1:09:33 the searchString field is reset and the comedy selected field is not reset when submitting the form, i dont understand why. I thought it would reset, as the controller does not reload the movieGenre property to return. I do not understand, why that select of the form does not reset to "All" after the page is rendered?
Hello, thanks for the question. As I really am not a compiler myself:), the best answer I can come up with is - replicate the code, put a break point on the correct place and debug. It should be visible. Or make a mcve (stackoverflow.com/help/minimal-reproducible-example ) and ask in StackOverflow.com, someone will debug for you there (if you make the mcve).
Please HOw can I do this with database , I need it for my end of year project at school
NEVER mind i just did a mistake ... YOU'RE A LIFESAVER THAAAAAAAAANK YOU SO MUCH
You are welcome 🙂
Thank you Vitosh for sharing this! Helped me a lot!
Thanks for the positive comment 😊🙂
Hello Vitosh , Could you help me share the sql database?
Hi, Music 52, thanks for commenting :). If you want to share the database, you need to put it somewhere, where other people may have access to it - on a hosting or on a cloud (AWS, Azure or others). Both AWS and Azure have out of the box solutions for MSSQL - aws.amazon.com/sql/?blog-posts-content-windows and azure.microsoft.com/en-us/services/sql-database/, and if it is for a non-commecrial usage (or a student's account) there could be something for free (not sure, though).
Pretty fun video! Hi, what about adding Mocks? For example various requests methods
Would you be able to display the blog and post in one page? Like a commenting system?
Run-time error '-21347024809 (80070057)': Invalid procedure call or argument From line: lineToPrint = item.codeModule.Lines(1, item.codeModule.CountOfLines) Extensibility module referenced and Trust enabled. While the export is very useful, the real trick is automating the import from the files back into the workbook.
When "item.CodeModule.CountOfLines" = 0, then the code crash
Dim component As VBIDE.VBComponent Compile Error: User-defined type not defined Microsoft Visual Basic for Applications Extensibility 5.3 Library
Sir please share source code link
do you have a youtube video regarding how to create a multi filter function to filter out multiple attributes ?
Simple and very good, Thank you
good explanation. and thanks for the table of contents. keep them coming!
you can use Gridify for that. it's more cleaner and easier way to do Filtering, Ordering, and pagination in your APIs. github.com/Alirezanet/Gridify
Thanks. There are plenty of ways to do filtering and ordering in C#.
I want to know how can i fill a 6x6 matrix on c# in reverse spiral form starting from center (clockwise) using windows forms, and instead of numbers the matrix should be filled with chars ?!
If the size is predefined, it is easier - use hard-coded values for the matrix initially. It does not matter it is not with numbers, but with chars. Whatever it is, follow the logic and fill it.
Hi! I hope you are well! I would like to ask you a question. How can i do the same thing you did on console application but in Windows Forms Application ?! It would mean a lot if you would help me. Thank you in advance!
We CAN´T see anything
Fullscreen and 1080HD should be ok... Or should I zoom a bit?
@@vitoshacademy man when I saw your videos intro, i thought, why so so few subscribers? and why no few views? and in first 10 seconds, I got the answers. Cant see a damn thing. text is so small that its impossible to read. consider improving in that part.
@@Harish-ou4dy thanks, I had to zoom a bit indeed.