Sometimes it is very necessary you get the last Column or last Row of your dataset in Excel This is a simple VBA code to get the Last Column and Last Row in your dataset Sub lastRow1() lastRow2 = Cells(Rows.Count, 2).End(xlUp).Row End Sub What the above code does is that, we are using the
These are quick reference charts about basic Statistics of your data. Skewness of the Data is described by the tail of the data. Left skewed means the tail points to the left and Right Skewed means the tail points to the right The Skewness and the position of the Mean and Median
Clone this github repository into YOUR OWN repository and Edit the link in the Readme.md file from https://www.herokucdn.com/deploy/button.svg)](https://heroku.com/deploy?template=https://github.com/dugjason/superset-on-heroku to the link in YOUR OWN CLONED repository eg. https://www.herokucdn.com/deploy/button.svg)](https://heroku.com/deploy?template=https://github.com/benadaba/hrmr Now scroll down and COMMIT (save) the changes ALSO edit the requirements.txt file and include any database requirements you want installed . eg pymssql==2.1.3, pyodbc==4.0.21 (this version was generating an
GDPR stands for General Data Protection Regulation (GDPR) also referred to as the EU General Data Protection Regulation (GDPR). According to the EUGDPR website , The EU General Data Protection Regulation (GDPR) is the most important change in data privacy regulation in 20 years. The EU General Data Protection Regulation (GDPR) replaces the Data Protection Directive 95/46/EC and was designed to harmonize
The sp_execute_external_script system stored procedure is the stored procedure which invokes the external environment to run an external script (either Python or R ) in a T-SQL script. This is quite highlights of the sp_execute_external_script stored and some short notes on it. let’s quickly look at the structure of the stored procedure sp_execute_external_script @language = N’language,
Sometimes, you might need some packages which do not come with the standard Python libraries and you would want to install them separately. You will notice how frustrating it is when you get stuck because of a package you are missing. Sentdex on Youtube covers that accurately and you can watch him here:
When someone applies for Credit, it will be unfair to reject those who duly qualify and it might be detrimental to the company to wrongly accept the wrong people. This is likely to happen if we try to make such decisions based on gut feelings. So how do we use Machine Learning to increase our
So I was at the SQLSaturday event in Manchester, United Kingdom on the 15th July 2017. According the SQLSaturday website, SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, and most costs are covered by donations and sponsorships. I would,
If you have ever worked with Java, Python, R, SQL, Excel and other Languages on a varied Data Science or Data Analytics projects, you will realise that all these languages have similar syntaxes, or at least, can achieve the same objective with very similar codes. Below is a comparison and similarities of these various tools
R is a very powerful language used in Data Science, Data Analytics and Stastistics in general. Having a knowledge of how R works will really help in your data analysis projects. This short article takes a snappy look at basic structure of creating a function in R and also a peep at Dates in R.
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
No products in the cart.