Trending YouTube Video Statistics

Daily statistics for trending YouTube videos from Kaggle

Image for post
Image for post
Photo by Christian Wiediger on Unsplash

R programming language is powerful when it comes to analyse and quickly visualise data. You can do that with RStudio easily. I explore daily statistics for trending YouTube videos, and you can find this data set from this link. Moreover, you can also find my Kaggle notebook regarding this work from this link.

The questions I am going to answer for this analysis are as the following:


An Opinion

New Roles Emerges as Technology Changes Expectations

Image for post
Image for post
Photo by Julius Drost on Unsplash

In the last decade, data scientist roles have increased enormously. Nowadays, almost every company is looking for a data scientist for their businesses. This role’s importance comes from its social and technical skills. A data scientist should have both these type of attributes in his/her toolbox. Especially, I believe that both social and technical skills are equally important in the News and Media industry. Even sometimes, social skills can be more important than technical ones. I would say %51 social, %49 technical.

First of all, two of the most important social aspects of the News and Media industry are presenting…


An Opinion

What did COVID-19 teach us in the sense of e-learning?

Image for post
Image for post
Photo by engin akyurt on Unsplash

Throughout history, people have always been keen to learn new information. They have wanted to learn about themselves, their neighbours, the world, the universe etc. They have learnt what they need by telling stories to each other, and after a period of time, they found more structured ways to pass this knowledge, which are building libraries and schools. Everything was just perfect in the sense of learning until the COVID-19 showed us that it is not. After the pandemic, I am sure that everybody started to question current school systems globally and how people should learn. I believe that technological…


Opinion

Pros and Cons of It

Image for post
Image for post
Photo by h heyerlein on Unsplash

Introduction

In today’s world, machine learning is a big part of our lives. We cannot even think of a world without it at the moment. It already started to take a huge portion of our day-to-day activities. In this article, I am going to try to go through some important possible outcomes of machine learning in the future. To make this article consume more easily, I will give its brief here.

Pros are maybe like these;

Cons are maybe like these;

Although the above lists are a bit vague right now…


Data Analysis Series: An Overview of FIFA 19 Players Dataset

Not Ronaldo, not Messi!

Image for post
Image for post
Photo by Philippe Leone on Unsplash

Intro

Not Messi, Not Ronaldo! You may laugh it as people in the picture 😀, but this statement is true! Of course, it is valid under some conditions 😀. We will look at those conditions in the next sections of this article.

Data analysis with Python is widespread in data space along with other popular programming languages such as R. However; in this article, we are going to do our research on a popular football game FIFA 19 with Python. You can find the dataset from this link. By the way, let me ask you this;

Who is your favourite player…


Data Analysis Series: An Overview of FIFA 19 Players Dataset

SQL Is Powerful but Is It Powerful Enough for This Important Job?

Image for post
Image for post
Photo by Bence Balla-Schottner on Unsplash

Intro

SQL is one of the most important language in data space. Even though there are lots of ways of dealing with data such as within Excel files, XML files, through APIs etc., dealing data within databases is always a big part of our professional lives. Naturally, SQL is the most common way to handle requests within databases. It is a must knowledge if you are interested in data space.

After having the technical introduction, I eager to ask to you;

Do you play football games? 😀

I can hear you all right! Yes, you do 😀. If you are interested…


Examining the Dataset in Tableau

Image for post
Image for post
Photo by Fachry Zella Devandra on Unsplash

Intro

In this article, we are going to try to find our striker for our team! In a hypothetically scenario, we have a team in FIFA 19 football simulation video game, and we have a very big budget! :) First, we analysed our squad and decided that we need a very good striker for our team. Here I can ask;

Who is your favourite striker in FIFA 19?

Of course, you can answer this question instantly according to your experiences in the game. However, there is an alternative way to answer this question. Data Analysis! :)

By the way, if you…


Image for post
Image for post
Photo by Tevarak Phanduang on Unsplash

Intro

FIFA is one of the most popular football simulation video games of all times. I am sure that not only me but most of the people (I guess the majority would be males) probably played this game once in their life. Especially if you are a football fan, then you played this game not only once. I, as a football fan, have played FIFA’s series for a long period of time, especially during my school years, and never got bored. :)

If you are still interested in this article after reading the intro, then let’s continue…

About the Content

Before going any further…


Image for post
Image for post
Photo by Obie Fernandez on Unsplash

In Today’s World, we have so many discussions and debates that seem as problems. However, when we examine them technically, it is easy to understand that they are actually not problems but there are lack of communication and misunderstandings between people. At this point, it is crucial to explain the aim of this work. The main purpose is to show that languages can be analysed technically, and meanings of words and sentences can be understood through sentiment points. These points can be accepted as almost same for every language so that this type of work can be adapted to any…


Image for post
Image for post
Photo by Mimi Thian on Unsplash

In previous section, we showed you how to copy data with VBA from one sheet to another in Excel. It is a good practice that you can use your VBA code for your similar data sets. If you haven’t read the previous section, you can read it from this link.

In this section, we are going to see how to check valid cell values in Excel. We will use the data set which we showed in the previous section. As you remember from that section, there are some incorrect values in some columns. Specifically, there seems two values wrong in…

Efe Buyuk

Hi 👋 , I write about Data Science. Let’s connect on LinkedIn http://tiny.cc/qb07tz | Follow me on GitHub http://tiny.cc/sb07tz

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store