Data Analysis

After taking a course on data mining and text analysis in Python, I was feeling confident and ambitious enough to take on a full fledged project using Python. I am usually more comfortable using R — it just makes so much sense to me. But I know that as I…

As you probably know, the World Cup is currently ongoing in Qatar. With that in mind, here at Pebble Stream, we decided to build a simple predictor using our free Google Sheets plugin, Zen. You can access it here to copy it to your own Google Drive. …

Objective: This post outlines the end to end Data+ML model pipeline creation process in Pyspark environment. It provides a brief comparison of pyspark over the ubiquitous pandas libraries(atleast in python circles). It then moves directly to a code example pipeline, which starts with training data, and results in prediction dataframe. …

Hierarchical indexing — In the previous chapters we saw how to use indexes. We either used the default index provided in the DataFrame or we converted a column into index. A Thorough Intro to Pandas for Data Analysis II Inspection, filtering and editionbattox.medium.com Now we will see more possibilities that Pandas offers to explore a DataFrame through the index and how we can have more than…

And what does the data say? For those who already know what Bineroo is, you can skip the introduction and directly dive into the exciting part. 👋Introduction Bineroo is a mobile game I have been developing for the past couple of years. It’s built using the Flutter framework. …

SQL Server stored procedures are used to group Transact-SQL statements into logical units that can be reused. When working on the SQL Server Database, the stored procedure is stored as a named object. Benefits of Stored Procedures There are lots of benefits to using stored procedures in your programs. Between them are: Stored procedures…

Learn to use parameters in SQL stored procedures, and make your code more versatile and reliable. — In this tutorial, we will dive into stored procedures. Learning about passing one or more parameters to it. This will cause the result of the stored procedure to change based on the values of the parameters inputted. Stored Procedures with one parameter We will create an example to show how the parameters work. Let’s say…

The map function is a built-in function in Python that allows you to run a specified function on each item in an iterable (such as a list, tuple, dictionary, or set). This is a powerful tool that can make your code more concise and efficient. Let’s take a look at…