• Home
  • All Posts
  • Tags
  • About
  • Atom feed
PhD2DataScience. Data science, visualizations, training, and learning

Learn

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

Visualize Real Estate Market trends in Ireland April 14, 2020 3 minute read

COVID-19 is a great opportunity to reflect on ourselves and to dedicate time and effort to things we normally cannot do during our normal busy lives. Hence, I decided to start writing my first Data Science related blog post.

In my first post I will cover the following content:

  1. Pull data from a website in the form of a csv and load it into Pandas
  2. Evaluate the data, manipulate and clean the data
  3. Visualize major trends in the data using matlpotlib, plotly and bokeh

Disclaimer and requirements

Everyone needs to start somewhere. Being my first post, I... read more

PgAdmin

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

PhD

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

SQL versus Python, who wins? July 31, 2020 5 minute read

I’m personally bombarded by articles and videos revolving around Python. Based on my experience however, SQL is the most fundamental tool that you will need from day one in any data role.

In this article I make the point that, based on my experience, SQL is the most important language you can learn when changing career and approaching data science. I started a quest to find the data that confirmed my hypothesis.

To help others that are in the process of learning SQL to understand the language faster, I started a series of lessons to explain SQL in plain English.... read more

Postgres

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

Programming

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

Visualize Real Estate Market trends in Ireland April 14, 2020 3 minute read

COVID-19 is a great opportunity to reflect on ourselves and to dedicate time and effort to things we normally cannot do during our normal busy lives. Hence, I decided to start writing my first Data Science related blog post.

In my first post I will cover the following content:

  1. Pull data from a website in the form of a csv and load it into Pandas
  2. Evaluate the data, manipulate and clean the data
  3. Visualize major trends in the data using matlpotlib, plotly and bokeh

Disclaimer and requirements

Everyone needs to start somewhere. Being my first post, I... read more

SQL

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

SQL versus Python, who wins? July 31, 2020 5 minute read

I’m personally bombarded by articles and videos revolving around Python. Based on my experience however, SQL is the most fundamental tool that you will need from day one in any data role.

In this article I make the point that, based on my experience, SQL is the most important language you can learn when changing career and approaching data science. I started a quest to find the data that confirmed my hypothesis.

To help others that are in the process of learning SQL to understand the language faster, I started a series of lessons to explain SQL in plain English.... read more

SQL admin

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

analytics

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

blog

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

SQL versus Python, who wins? July 31, 2020 5 minute read

I’m personally bombarded by articles and videos revolving around Python. Based on my experience however, SQL is the most fundamental tool that you will need from day one in any data role.

In this article I make the point that, based on my experience, SQL is the most important language you can learn when changing career and approaching data science. I started a quest to find the data that confirmed my hypothesis.

To help others that are in the process of learning SQL to understand the language faster, I started a series of lessons to explain SQL in plain English.... read more

bokeh

Visualize Real Estate Market trends in Ireland April 14, 2020 3 minute read

COVID-19 is a great opportunity to reflect on ourselves and to dedicate time and effort to things we normally cannot do during our normal busy lives. Hence, I decided to start writing my first Data Science related blog post.

In my first post I will cover the following content:

  1. Pull data from a website in the form of a csv and load it into Pandas
  2. Evaluate the data, manipulate and clean the data
  3. Visualize major trends in the data using matlpotlib, plotly and bokeh

Disclaimer and requirements

Everyone needs to start somewhere. Being my first post, I... read more

career

Explore career opportunities while pursuing your PhD. July 6, 2020 4 minute read

Only 0.45% of science PhDs that graduate every year will ever become professors. You better start looking for alternatives.

If you are attending a PhD programme, chances are you consider yourself quite smart. Most likely you are very dedicated and you possess the grit to go down an intense and challenging path… But do you really think you are part of the 0.45% 1?

The number of doctoral degrees awarded has more than doubled since between 2000 and 2018. In the academic job market that keeps shrinking and is becoming more and more competitive, the opportunities for the... read more

career changes

Explore career opportunities while pursuing your PhD. July 6, 2020 4 minute read

Only 0.45% of science PhDs that graduate every year will ever become professors. You better start looking for alternatives.

If you are attending a PhD programme, chances are you consider yourself quite smart. Most likely you are very dedicated and you possess the grit to go down an intense and challenging path… But do you really think you are part of the 0.45% 1?

The number of doctoral degrees awarded has more than doubled since between 2000 and 2018. In the academic job market that keeps shrinking and is becoming more and more competitive, the opportunities for the... read more

crypto

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

crypto trading

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

cryptocurrency

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

data science

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

SQL versus Python, who wins? July 31, 2020 5 minute read

I’m personally bombarded by articles and videos revolving around Python. Based on my experience however, SQL is the most fundamental tool that you will need from day one in any data role.

In this article I make the point that, based on my experience, SQL is the most important language you can learn when changing career and approaching data science. I started a quest to find the data that confirmed my hypothesis.

To help others that are in the process of learning SQL to understand the language faster, I started a series of lessons to explain SQL in plain English.... read more

data visualization

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

Visualize Real Estate Market trends in Ireland April 14, 2020 3 minute read

COVID-19 is a great opportunity to reflect on ourselves and to dedicate time and effort to things we normally cannot do during our normal busy lives. Hence, I decided to start writing my first Data Science related blog post.

In my first post I will cover the following content:

  1. Pull data from a website in the form of a csv and load it into Pandas
  2. Evaluate the data, manipulate and clean the data
  3. Visualize major trends in the data using matlpotlib, plotly and bokeh

Disclaimer and requirements

Everyone needs to start somewhere. Being my first post, I... read more

database

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

database administrator

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

datascience

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

equities

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

front-end

Create a Jekyll-based static website from scratch Part I March 18, 2020 4 minute read

I’ve imagined this tutorial as a series of posts, to share my experience in building a static website based on Jekyll. I hope this will be helpful to help you getting started in building your own website based on Jekyll.

In the first post I will cover the following content:

  1. Brief Summary of what is Jekyll and what are the advantages of using it
  2. Requirements and folder structure
  3. Preliminary configuration of the config.yml file
  4. Summary and next post

Disclaimer and requirements

This guide is based on MacOS.

What is Jekyll and what are the advantages of... read more

iTerm2

Installing Python in less than 9999 steps! July 12, 2020 4 minute read

Yes, this is yet another Python installation guide. However, it is different from most as I verified the steps and it should run smoothly without errors when you have a clean OS installation. I’ve used MacOS Catalina freshly installed.

How this is going to work? I’m going to give you the sequence of steps that you need to run to install Python, the virtual environment manager, Jupyter notebook and Oh My Zsh. Starting from a basic terminal …

Vanilla iTermThe Vanilla version of iTerm2

You will obtain a poweruser terminal similar to this

Poweruser iTerm read more

investment

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

Visualize Real Estate Market trends in Ireland April 14, 2020 3 minute read

COVID-19 is a great opportunity to reflect on ourselves and to dedicate time and effort to things we normally cannot do during our normal busy lives. Hence, I decided to start writing my first Data Science related blog post.

In my first post I will cover the following content:

  1. Pull data from a website in the form of a csv and load it into Pandas
  2. Evaluate the data, manipulate and clean the data
  3. Visualize major trends in the data using matlpotlib, plotly and bokeh

Disclaimer and requirements

Everyone needs to start somewhere. Being my first post, I... read more

jekyll

Create a Jekyll-based static website from scratch Part I March 18, 2020 4 minute read

I’ve imagined this tutorial as a series of posts, to share my experience in building a static website based on Jekyll. I hope this will be helpful to help you getting started in building your own website based on Jekyll.

In the first post I will cover the following content:

  1. Brief Summary of what is Jekyll and what are the advantages of using it
  2. Requirements and folder structure
  3. Preliminary configuration of the config.yml file
  4. Summary and next post

Disclaimer and requirements

This guide is based on MacOS.

What is Jekyll and what are the advantages of... read more

jupyter notebook

Installing Python in less than 9999 steps! July 12, 2020 4 minute read

Yes, this is yet another Python installation guide. However, it is different from most as I verified the steps and it should run smoothly without errors when you have a clean OS installation. I’ve used MacOS Catalina freshly installed.

How this is going to work? I’m going to give you the sequence of steps that you need to run to install Python, the virtual environment manager, Jupyter notebook and Oh My Zsh. Starting from a basic terminal …

Vanilla iTermThe Vanilla version of iTerm2

You will obtain a poweruser terminal similar to this

Poweruser iTerm read more

machine learning

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

opportunities

Explore career opportunities while pursuing your PhD. July 6, 2020 4 minute read

Only 0.45% of science PhDs that graduate every year will ever become professors. You better start looking for alternatives.

If you are attending a PhD programme, chances are you consider yourself quite smart. Most likely you are very dedicated and you possess the grit to go down an intense and challenging path… But do you really think you are part of the 0.45% 1?

The number of doctoral degrees awarded has more than doubled since between 2000 and 2018. In the academic job market that keeps shrinking and is becoming more and more competitive, the opportunities for the... read more

personal

Explore career opportunities while pursuing your PhD. July 6, 2020 4 minute read

Only 0.45% of science PhDs that graduate every year will ever become professors. You better start looking for alternatives.

If you are attending a PhD programme, chances are you consider yourself quite smart. Most likely you are very dedicated and you possess the grit to go down an intense and challenging path… But do you really think you are part of the 0.45% 1?

The number of doctoral degrees awarded has more than doubled since between 2000 and 2018. In the academic job market that keeps shrinking and is becoming more and more competitive, the opportunities for the... read more

Creating my website at the time of Coronavirus March 16, 2020 1 minute read

Make good use of a pandemic world lock down.

This is my first post.

I'm currently in lock down mode. Ireland is not waiting for the Coronavirus pandemic to spread too broadly. Offices are closed (or closing), employees are asked to work from home and schools are closed. During my morning run I observed a city that is still very much active, nothing resembling the safe isolation of my home country (Italy).

However, this is a good compromise between waiting for the herd immunity to kick in and the full lock down mode applied... read more

phd2datascience

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

SQL versus Python, who wins? July 31, 2020 5 minute read

I’m personally bombarded by articles and videos revolving around Python. Based on my experience however, SQL is the most fundamental tool that you will need from day one in any data role.

In this article I make the point that, based on my experience, SQL is the most important language you can learn when changing career and approaching data science. I started a quest to find the data that confirmed my hypothesis.

To help others that are in the process of learning SQL to understand the language faster, I started a series of lessons to explain SQL in plain English.... read more

plotly

Visualize Real Estate Market trends in Ireland April 14, 2020 3 minute read

COVID-19 is a great opportunity to reflect on ourselves and to dedicate time and effort to things we normally cannot do during our normal busy lives. Hence, I decided to start writing my first Data Science related blog post.

In my first post I will cover the following content:

  1. Pull data from a website in the form of a csv and load it into Pandas
  2. Evaluate the data, manipulate and clean the data
  3. Visualize major trends in the data using matlpotlib, plotly and bokeh

Disclaimer and requirements

Everyone needs to start somewhere. Being my first post, I... read more

post

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

SQL versus Python, who wins? July 31, 2020 5 minute read

I’m personally bombarded by articles and videos revolving around Python. Based on my experience however, SQL is the most fundamental tool that you will need from day one in any data role.

In this article I make the point that, based on my experience, SQL is the most important language you can learn when changing career and approaching data science. I started a quest to find the data that confirmed my hypothesis.

To help others that are in the process of learning SQL to understand the language faster, I started a series of lessons to explain SQL in plain English.... read more

programming

Create a Jekyll-based static website from scratch Part I March 18, 2020 4 minute read

I’ve imagined this tutorial as a series of posts, to share my experience in building a static website based on Jekyll. I hope this will be helpful to help you getting started in building your own website based on Jekyll.

In the first post I will cover the following content:

  1. Brief Summary of what is Jekyll and what are the advantages of using it
  2. Requirements and folder structure
  3. Preliminary configuration of the config.yml file
  4. Summary and next post

Disclaimer and requirements

This guide is based on MacOS.

What is Jekyll and what are the advantages of... read more

programming language

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

SQL versus Python, who wins? July 31, 2020 5 minute read

I’m personally bombarded by articles and videos revolving around Python. Based on my experience however, SQL is the most fundamental tool that you will need from day one in any data role.

In this article I make the point that, based on my experience, SQL is the most important language you can learn when changing career and approaching data science. I started a quest to find the data that confirmed my hypothesis.

To help others that are in the process of learning SQL to understand the language faster, I started a series of lessons to explain SQL in plain English.... read more

python

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

SQL versus Python, who wins? July 31, 2020 5 minute read

I’m personally bombarded by articles and videos revolving around Python. Based on my experience however, SQL is the most fundamental tool that you will need from day one in any data role.

In this article I make the point that, based on my experience, SQL is the most important language you can learn when changing career and approaching data science. I started a quest to find the data that confirmed my hypothesis.

To help others that are in the process of learning SQL to understand the language faster, I started a series of lessons to explain SQL in plain English.... read more

real estate

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

Visualize Real Estate Market trends in Ireland April 14, 2020 3 minute read

COVID-19 is a great opportunity to reflect on ourselves and to dedicate time and effort to things we normally cannot do during our normal busy lives. Hence, I decided to start writing my first Data Science related blog post.

In my first post I will cover the following content:

  1. Pull data from a website in the form of a csv and load it into Pandas
  2. Evaluate the data, manipulate and clean the data
  3. Visualize major trends in the data using matlpotlib, plotly and bokeh

Disclaimer and requirements

Everyone needs to start somewhere. Being my first post, I... read more

static-website

Create a Jekyll-based static website from scratch Part I March 18, 2020 4 minute read

I’ve imagined this tutorial as a series of posts, to share my experience in building a static website based on Jekyll. I hope this will be helpful to help you getting started in building your own website based on Jekyll.

In the first post I will cover the following content:

  1. Brief Summary of what is Jekyll and what are the advantages of using it
  2. Requirements and folder structure
  3. Preliminary configuration of the config.yml file
  4. Summary and next post

Disclaimer and requirements

This guide is based on MacOS.

What is Jekyll and what are the advantages of... read more

stocks

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

terminal

Installing Python in less than 9999 steps! July 12, 2020 4 minute read

Yes, this is yet another Python installation guide. However, it is different from most as I verified the steps and it should run smoothly without errors when you have a clean OS installation. I’ve used MacOS Catalina freshly installed.

How this is going to work? I’m going to give you the sequence of steps that you need to run to install Python, the virtual environment manager, Jupyter notebook and Oh My Zsh. Starting from a basic terminal …

Vanilla iTermThe Vanilla version of iTerm2

You will obtain a poweruser terminal similar to this

Poweruser iTerm read more

trading

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

training

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

tutorial

Become a SQL database administrator, build your first database in Postgres and become 10x faster in your daily ETL routines September 27, 2020 9 minute read

Everything starts for a reason…I was playing around with some messy data that I wanted to tame for a personal data science project. I automatically, without thinking, imported the data in Python.

I got bored. Python is not the elective language to clean and manage data. Personally, I have experience and I’m comfortable using SQL which is my go-to language to manage clean and wrangle data. SQL has the advantage of being extremely efficient in transforming operations and pre-exploratory data analysis.

What are the advantages of SQL ETL versus Python ETL? I recently came across an article that compared... read more

visualization

Cryptovaluer. A tool to help you navigate crypto currency technical signals. January 31, 2022 5 minute read

What would you do if you had tool that could decrease the time spent trying to understand the patterns and behaviors of currently active crypto coins? Imagine an app that supports your crypto coin analysis, that’s what I’m building.

This is my first article in a while. Checking in, my last piece was in 2020, during the first months of global lockdowns. A lot happened to me and to the rest of the world since then. However, my need and will to create content, improve my technical capabilities, and become financially independent never disappeared.

In 2022, I want to produce... read more

Naive clustering of different stocks April 19, 2020 5 minute read

Why investing in the financial market is important

It’s been a couple of years that I tried to become more proficient in investing. The basic assumption is that, unlike my father, I won’t have access to a comfortable state pension once I’m around my retirement age. Actually, nowadays retirement ages are keeping increasing, thus I believe there is a risk that I will have to continue working until 80 years old… This is something I’d like to avoid, if possible!

For this reason, I started with simple ETFs, using Dollar-Cost Averaging. This strategy is very simple and doesn’t... read more

Visualize Real Estate Market trends in Ireland April 14, 2020 3 minute read

COVID-19 is a great opportunity to reflect on ourselves and to dedicate time and effort to things we normally cannot do during our normal busy lives. Hence, I decided to start writing my first Data Science related blog post.

In my first post I will cover the following content:

  1. Pull data from a website in the form of a csv and load it into Pandas
  2. Evaluate the data, manipulate and clean the data
  3. Visualize major trends in the data using matlpotlib, plotly and bokeh

Disclaimer and requirements

Everyone needs to start somewhere. Being my first post, I... read more

web-development

Create a Jekyll-based static website from scratch Part I March 18, 2020 4 minute read

I’ve imagined this tutorial as a series of posts, to share my experience in building a static website based on Jekyll. I hope this will be helpful to help you getting started in building your own website based on Jekyll.

In the first post I will cover the following content:

  1. Brief Summary of what is Jekyll and what are the advantages of using it
  2. Requirements and folder structure
  3. Preliminary configuration of the config.yml file
  4. Summary and next post

Disclaimer and requirements

This guide is based on MacOS.

What is Jekyll and what are the advantages of... read more

  • Learn (2)
  • PgAdmin (1)
  • PhD (5)
  • Postgres (1)
  • Programming (2)
  • SQL (2)
  • SQL admin (1)
  • analytics (1)
  • blog (6)
  • bokeh (1)
  • career (1)
  • career changes (1)
  • crypto (1)
  • crypto trading (1)
  • cryptocurrency (1)
  • data science (8)
  • data visualization (2)
  • database (1)
  • database administrator (1)
  • datascience (2)
  • equities (1)
  • front-end (1)
  • iTerm2 (1)
  • investment (3)
  • jekyll (1)
  • jupyter notebook (1)
  • machine learning (1)
  • opportunities (1)
  • personal (2)
  • phd2datascience (6)
  • plotly (1)
  • post (6)
  • programming (1)
  • programming language (2)
  • python (4)
  • real estate (2)
  • static-website (1)
  • stocks (1)
  • terminal (1)
  • trading (2)
  • training (1)
  • tutorial (1)
  • visualization (3)
  • web-development (1)

    2022 © Manfredi Miraula

    Posts
    Tags
    About