I was working with a CSV file on a project and after reading the CSV into the Program with the pandas.read_csv function the returned data type seemed not be a Dataframe for some reason code was as follows: sample = pd.read_csv(‘sample.csv’) When i tried to run some functions on the supposed ‘returned dataframe object -sample’ I…
I receive a lot of emails about where to get quick and excellent resources for explaining most of the concepts of Transact-SQL (T SQL) and Microsoft SQL Server in general What is Transact-SQL or T SQL. T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query…
A friend of mine asked me to take him through VLookUp Excel function. VLookUp is a powerful function in Excel which when well understood, will make your working with data in excel very easy . I found a very good tutorial on Youtube by ExcelIsFun which covers VLookUp and HLookUp. It covers over 25 Exercises on…
Sometimes, you need some mock or test data to either test your program or for your analysis or to populate your database. Or sometimes, you need some sample or mock data to illustrate or explain a concept but you do not want to use your companies’ data or your delicate data. There are a…
I was working on a Kaggle.com competition about sales forecasting and realised there are a lot of libraries in “R” that do a lot of forecasting and generally make forecasting pretty straight forward. What is “R” in the first place in the sphere of statistics and Data Science: R is a programming language and…
This is a list of some of the job websites in the UK where you can apply for your DataScience and Big Data jobs. The order does not attach any significance to any particular jobs. CV Library CWJobs Dice (formerly the IT Job Board) Fish4Jobs Games Industry Jobs Indeed inMail LinkedIn (you can apply to…
Have you ever thought of tackling Data Science competitions from top competition websites such as Kaggle.com or you have a Data Science project and you are not sure how to start on it or where to start exactly from and how to go through it ? Or you simply have an idea but want to…
SQL Joins can sometimes be a bit confusing, particularly if you a newbie. I have below 2 visual representations which should help enhance your visual understanding of SQL JOINS First is from From CodeProject, by C L Moffatt You can check full explanation here: Sql Joins visually explained 2. Second was from Duke University….
When installing MySql server package, you can instruct the installation to configure MySql server to start automatically on each windows start up. However, if you want to reserve resources whilst you will not be working with the MySql server and hence you do not want the server to automatically start up on every boot of…
Summarizing Data This week we are looking at five most common aggregate functions used to summarize information stored in tables: COUNT and SUM very frequently. COUNT is the only aggregate function that can work on any type of variable. The other four aggregate functions are only appropriate for numerical data. All aggregate functions require you…
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
No products in the cart.