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

Pass and convert pdf to csv and excel

Looking at the historical data offered by a meteorological observatory in my city, I see that they only offer them graphically and for download as PDF. I don't understand why they don't let you download them in csv, which would be much more useful for everyone.

So I've been looking for one solution to pass these tables from pdf to csv or if someone wants to format Excel or Libre Office. I like csv because with a csv you do everything you can handle it with python and its libraries or you can easily import it into any spreadsheet.

As the idea is to get an automated process, what I want is a script to work with Python and this is where Tabula comes in.

Read

Anaconda Tutorial: What it is, how to install it and how to use it

Anaconda Data Science, big data and pytho, R distribution

In this article I leave a Anaconda installation guide and how to use your Conda package manager. With this we can create development environments for python and R with the libraries we want. Very interesting to start messing with Machine Learning, data analysis and programming with Python.

Anaconda is a free and Open Source distribution of the Python and R programming languages ​​widely used in scientific computing (Data ScienceData Science, Machine Learning, Science, Engineering, predictive analytics, Big Data, etc).

It installs a large number of applications widely used in these disciplines all at once, instead of having to install them one by one. . More than 1400 and that are the most used in these disciplines. Some examples

  • Numpy
  • pandas
  • Tensorflow
  • H20.ai
  • scipy
  • Jupyter
  • Dashboard
  • OpenCV
  • matplotLib

Read

How to see hidden password with dots or asterisks

How to see password that we have forgotten and is hidden by dots or asterisks

Sure sometime You have forgotten a password but your browser remembers it even though it is hidden with dots or asterisks and in the end you end up changing it. Well, there are several methods to see this password, I know two, go to preferences of our browser to see where it saves the password and the second is the method that we are going to teach very, very simple and more powerful because it allows us to see passwords saved in fields , that is to say, that although we have not saved them and of course, it is not in our browser, we can see them.

This is very useful if for example you work as a team and someone puts an API in a form, as in WordPress, this way you can quickly retrieve it to reuse it elsewhere.

I leave you the video with teaching how to do it and below I explain the two methods in traditional format (inspector and browser password manager)

Read

How to install Keras and TensorFlow from backend on Ubuntu

how to install keras on ubuntu

After finishing the Machine Learning course, I was looking where to continue. The development environments used in the Octave / Matlab prototyping course are not what people use, so you have to jump to something higher quality. Among the candidates that have been recommended to me the most is Keras, using backend TensorFlow. I'm not going to go into whether Keras is better than other tools or other frameworks or whether to choose TensorFlow or Theano. I'm just going to explain how it can be installed in Ubuntu.

First, I tried to install it from the documentation of the official pages, and it was impossible, I always had an error, an unresolved question. In the end I went to find specific tutorials on how to install keras in Ubuntu And yet I have spent two days spending a lot of time at night. In the end I have achieved it and I leave you how I have done it in case it can pave the way for you.

As we are going to follow the steps recommended by the websites that I leave you from sources at the end of the tutorial, we are going to install PIP that I did not have, to manage the packages. pip on linux it's just that, a package management system written in python.

sudo apt-get install python3-pip sudo apt install python-pip

Read

How to edit images in batches or batch (in bulk) with Gimp

BIMP GIMP plugin to edit and manipulate images and photos in batch

Use Gimp as a photo and image editor. I haven't touched Photoshop in a couple of years. Even when I was using Windows I stopped using Photoshop because I didn't want to hack it.

There are different ways to modify images in bulk, in bulk, in batches or bulk, whatever we want to call it. But this Gimp extension seems indispensable to me. Allows us scale images, add watermarks, rotate them, change the format, reduce the weight and many other actions that we will do in bulk and in a very short time. You will not believe the amount of time you are going to save.

I use it mostly to edit the images of blog articles. I size them right, add the watermark, and reduce the weight in seconds. But I see it useful for many people besides Webmasters, photographers who want to add watermarks. Or if you are looking to resize multiple photos or images at the same time.

I have changed my methodology. Now to add watermarks I use a Bash script. I leave everything explained here.

I leave you first what it does and then how to install it in case you are interested.

Read

Six months with Linux

This is Linux, I show you my desktop

Lately many people in my environment ask me about LinuxThey even want you to install it to test it. So now that I've been using Linux for everything for 6 months, I think it's a good time to share my experience.

Use Ubuntu for 6 years on the laptop but not intensive way or to work, the laptop is for leisure, browsing and some Arduino stuff. For a long time I tried to install some distribution on my PC, but my old GForce 240T graphics gave problems and although they tried to help me to correct the problems and install the correct drivers, in the end I got tired and continued with Windows 7 and then 10. I tried Debian, Ubuntu, Linux Mint, and some more and I could not install any. The truth is that I no longer remember if I tried something that was not based on Debian.

But a few months ago I had a Manjaro distro ready on the USB and I thought why not? and see where it worked and also great. I love Manjaro. I have been using this distribution for about a month and I fell in love with its Theme Maia. But there was an update that gave problems again with all the Nvidia (Rolling Release stuff?) So I tried Kubuntu, which had never been able to install it and had no problem. And so I've been using Kubuntu for more than 6 months in my day to day.

Read

My first impression with Ubuntu

I've been using Ubuntu for two weeks. After posting the article on how to use ubuntu from a USB I decided to install it together with windows 7.

The extremely simple installation, from the same USB, made the partitions by itself, and with 3 or 4 clicks to work and then the surprise arrived.

ubuntu operating system

Read

Use Ubuntu Linux from a USB

This weekend has been a black weekend when it comes to PC. After a long time with problems, my windows vista decided to stop working.

After several formatting-installation-formatting-installation, it seems that windows 7 heeds what I say, although I still have a half hard disk with information that has not been deleted.

So I have decided to try other options, which go through a Linux distribution. On the page of Ikkaro from Facebook, I have been recommended Ubuntu, which I have already heard a lot about.

universal linux installer from usb

Read