How to convert tables from PDF to Excel or CSV with Tabula

convert pdf into csv and extract data from tables

One of the most laborious tasks in Machine Learning consists of data collection and treatment.

There are a meteorological observatory in my city. You can see main meteorological indicators in real time trough its we and it share historical data too, but it share it in PDF

I have talk with them in order to share all data in CSV and allow people to use the data easily, but it seems that is not possible ­čÖü

Therefore I want this data and I want to convert this PDF files to a workable data collection. And I have been searching a good solution to convert this table PDF to CSV and the solution is called Canvas.

Once you have data in CSV you can use this data in many ways, opening with excel, Libre office, Google Sheets, etc, because is easy import them in spreedsheets or using pythons and its libraries.

As I want an automatized process I will work with a python script and is here where I introduce Tabula.

Read moreHow to convert tables from PDF to Excel or CSV with Tabula

How to unlock a phone with a broken screen

How to unlock a phone wita a broken screen using a OTG wire

In this article we will see how to unlock a phone with a broken screen, in order to access to its hard drive and transfer and recovery files, images and videos.

Some time ago my wife dropped the phone a BQ Aquaris E5 and the screen broke, it seemed nothing exaggerated, but the bottom does not work. We can see the screen and switch on it, but we can write the Unlock pattern and therefore it is unusable. As we want to recover photographies and videos I begin to deal with the problem.

I have been looking for many options to recover photograpies. The first one we thought was to change de smartphone screen and the second ond one to use a softare that broke unlock patterns. finally, after much searching I tried OTG method. And is the best if your can use it with your device. Not all smartphones and tablets allow to connect and work with this technology.

I let you a video unlocking my wife’s phone with a mouse and an OTG female cable. (video has english subtitles)

There are different cases:

You see the screen.

I saw multiples choices and the easier one has been to buy an OTG cable (only $1,3)

OTG is the On The Go acronym, and is a USB 2.0 extension which allows to conect usb peripheral to our device. This way we are able to connect a mouse and navigate like in a PC.

Once you have a mouse connected with a OTG cable you draw your unlock pattern holding the left button pressed. This way you can browse with mouse open menus with left button and close it with the right one.

Is effortless and useful. And you can use OTG also with tablets and mobiles that are not damaged connecting keyboards, mouses or USB microscopes.

So you know. If you need to unlock a phone mobile with a broken screen check if work through OTG and use the mouse.

Now the other case.

Black screen, it does not work

This is a hard case. You do not see the screen it remains in black although you switch on the mobile. All the software I have found to solve this problem requires to have debugging USB mode activated and no one has it. A good option is to search another screen and change it

Software to access in a lock mobile phone

I am looking for a soft which allow to access to hard drive and extract information. If you know any method, software, article, tutorial or whatever you know, please leave a comment and I will go completing this article to help as many people as possible.

How to make Galalith or plastic stone. A bioplastic from milk

This is an easy experiment, awesome for kids. Making it we will can explain our children what bioplastic are and introduce them into a chemistry world. Even in historical facts.

Galalith or Milkstone has an interesting history behind it. It was use to produce gemestone realistic imitations.

Other Galalith names: Milkstone, Erinoid (United Kingdom), aladdinite (USA), Casolith (Netherlands) and lactoloid (Japan).

Read moreHow to make Galalith or plastic stone. A bioplastic from milk

How to Install and manage Anaconda

Anaconda Data Science, big data & pytho, R disribuci├│n

This article is an Anaconda installation guide and also a guide of its packages manager, Conda. With this technology we will be able to create development environment for Python and R with the libraries we prefer. It is very interesting to begin learn Machine Learning, data analysis and programming with Python.

Anaconda is a Free and Open Source distribution for Python and R languages. It is very used in Data Science, Machine Learning, Science, Engineering, predictive analytics,Big Data, etc

Installing Anaconda we can use a great quantity of packages. There are more than 1400 of the most known applications and software. Some examples are:

  • Jupyter Notebook
  • Numpy
  • Pandas
  • Tensorflow
  • Scipy
  • Jupyter
  • Dask
  • OpenCV
  • MatplotLib
  • Scarapy

Read moreHow to Install and manage Anaconda

Coursera Machine Learning course Review

Last year I finished Machine Learning Coursera course by Stanford University and Andrews Ng

Is a free course about Machine Learning and a little of Deep Learning created by Andrew Ng and Stanford University. Although it’s free you can to purchase a certificate by $70.  It is divided into 3 basis , videos, quizzies and programation excercises.

You see the videos, do a quizz and a practice exercices, designing a part of an algorithm and implementing and testing it with Matlab or Octave

Read moreCoursera Machine Learning course Review

How to make fake snow

how to make fake snow

I’ve wanted to try snowmaking (to make fake snow)for a long time. This is a handcraft that will help us to decorate our nativity scene at Christmas or if we make a model with the little ones and we want to give it a touch of realism with snow. Or just to get your hands dirty and enjoy for a while.

I have tried 5 different methods to have artificial snow, I show them to you and compare them throughout the article. Internet is full of tutorials on how to make snow in diapers and I find it a disastrous activity and not suitable for children.

After a first frustrated attempt I liked the experience so little that I have looked for more method to make homemade artificial snow, in a much safer, spectacular way and that you can do easily with your children. Here you have it all.

Read moreHow to make fake snow

Courses to learn Machine Learning, Deep Learning and AI

courses about machine learning, deep learning. The importance of Data

These are good resources I have found to learn yourself Machine Learning, Deep Learning and other AI subjects.

There are free and paid courses and different levels.

Free Courses


Divided into short courses (from 1 to 20 hours ). These are courses to take a first contact with the subject

Read moreCourses to learn Machine Learning, Deep Learning and AI