Skip to Content

Using import.io to extract any data from the web into Lumira (shuffle up and deal edition)

Update: If you want to take a look at how to push this data into HANA directly, take a look at my other import.io blog here


I am a huge Poker fan. I played so many on and offline games in my life that I just can’t even remember my first. What I do remember though is the first time I saw the WSOP on television. The world series of Poker is the game of games, the big daddy of them all and I plan on winning it once. Coincidentally it runs at the same time as the World Soccer Championship so I can’t make it this year (poor excuse ofcourse, nobody wants to couch up my 10k entry fee ;-).


To at least do my part for the WSOP 2014 edition, I thought it would be fun to load up Lumira with WSOP stats (sort of what Nic did with his Soccer Analysis) and see if I could make a nice storyboard which I could share with the world.

Well I did and here it is:

Naamloos.png

You can use the following URL to play with the data yourself:

https://cloud.saplumira.com/open?key=5394242A45E311DDE10000000A4E423F&type=HANALYTIC

Now the interesting part of this blog is not that Phil Hellmuth has the most bracelets and “in the moneys”, but doesn’t come close to Antonio Esfandiari’s life earnings, the interesting part is what I did to get the data!

Import.io, Lumira’s new best friend


Getting data could be a challenge. Ofcourse you can find an online csv data set or use an API to get your data, but sometimes you see some great data on a website and need to find a way to extract it into a file. This is where import.io comes in. It can extract data from any website and has a ton of features to share your newly gathered data. I suggest you take a look at their website to get an idea:

https://import.io/

They are truly awesome and their service is free!

Downloading stats from the WSOP website


In my example I used import.io to get the stats from the WSOP website. The process is very simple using the import.io wizard.

Looking at the WSOP page, we can see that we have pages and pages of stats. Would be very clumsy to go through every single page and copy/paste the information into a spreadsheet. This is where import.io proves its usefulness.

Naamloos.png

After installing the software you can start your extraction process. As you can see there are three options when extracting the data:

Naamloos.png

In one of my first attempts I used “Crawler” but it took a lot of time to get the data, as import.io is literally crawling through the entire website to collect the data. As I know exactly where my data is, I can use “Extractor”.

Enter your URL and press “lets get cracking”

Naamloos.png

I choose “Extractor”:

Naamloos.png

Press the big shiny button and the wizard investigates my page:

Naamloos.png

My data is in a table so I select table:

Naamloos.png

Import.io recognized my table and neatly creates my file layout and extracts the data found on the first page:

Naamloos.png

Note that I skip my first row of data as import.io is smart enough to find the column headings by investigating the HTML. After pressing “I’ve got what I need” I’m done and ready to load my settings to the cloud

As my data is on multiple pages (and I didn’t use “crawl” to extract my data!), I need to enter the URL of the pages where the data is:

Naamloos.png

After pressing refresh I have all I need!

I can now press download on the top of the page to download the data in a variety of formats. I choose csv.

  • For your convenience, a link to my import.io dataset:
  • And to the extracted csv:

The file can easily be loaded in Lumira and much to my surprise I have even more data then was on the page itself:

Naamloos.png

As the images of the players countries are labeled with the country name, I can even create a world map of the data automatically in Lumira. Life is good 😉

Lumira Cloud


Don’t forget to load your data into the Lumira Cloud. Visual discoveries are a nice way to get some insights from your data automatically.

Naamloos.png

And guess what… Lumira also found out that Antonio Esfandiairi’s earnings are extraordinary:

Naamloos.png

Lumira doesn’t explain whyso I’ll let you in on the “secret”:

Antonio paid a hefty 1 million to enter the “one drop” game and won a staggering 18.3 milllion! Guess he liked the odds.

Naamloos.png

I know who to contact to get my 10k buyin for next years WSOP 😉

Thank you for reading and take care,

Ronald.

7 Comments
You must be Logged on to comment or reply to a post.
  • Situs Resmi DEWA POKER Menyediakan Link Alternatif Daftar Dewa Poker yang aman terpercaya Untuk anda yang ingin bergabung bermain Di Situs terbaik. Deposit Hanya Rp 25.000, daftar dewa poker online sekarang juga. merupakan Agen judi online daftar dewa poker 88 serta poker99 serta dominoqq terpercaya, terbaik dan juga terpopuler di indonesia bakkan di Asia. Link alternatif poker88asia agar bisa login poker88 asia ,game poker88 asia dengan uang asli poker88. Poker88.Asia Adalah Poker Online Terbesar Di Asia, Poker 88 online game judi poker di asia terbukti, sistem deposit dan withdraw dengan layanan cepat, banyak promosi bonus menarik dan fitur baru poker tournament.

  • Dewapoker Adalah Situs Judi Online Terpercaya Yang Ada Sejak Tahun 2015 Memberikan Berbagai Kenyamanan Dan Menjadi Agen BandarQ, Situs Bandar Judi DewaPoker Di Indonesia. Live Dealer terbaru di Indonesia hanya di dewapoker segera gabung dan dapatkan bonus hingga 30 juta rupaih untuk season ini dan juga cashback hingga 5%.

  • Susah Menemukan AKTIFQQ Yang Aman Tanpa Robot/Admin??
    Segera Bergabung Dengan Kami Bagi Penggemar Poker Online..
    Aktifqq Situs Agen Judi Poker Online Terpercaya di Indonesia..
    Kepuasan Para Member Kami adalah Target dan Pencapaian Yang Kami Inginkan

    Kelebihan Aktifqq sebagai salah satu agen Bandar Poker dan Dominoqq online terpercaya Terbaik Se-Indonesia yaitu :
    1. Proses dana AMAN & CEPAT hanya 1 menit saja.
    2. 24 jam pelayanan CS yang ramah dan baik terhadap member.
    3. 100% FAIR PLAY tanpa adanya robot, admin ataupun kecurangan.
    4. Kerahasiaan member dijamin aman.
    5. Kemenangan Berapa pun Akan Kami Bayar !
    5. Bonus Refferal 20% [TERBESAR] [SEUMUR HIDUP]
    6. Bonus TurnOver 0,5% [TERBESAR][Setiap Hari]

    Games Yang Tersedia :
    1. Poker
    2. Bandar Poker
    3. DominoQQ
    4. AduQ
    5. BandarQ
    6. Capsa Susun
    7. Sakong
    8. Bandar 66
    9. Perang Baccarat (TERBARU!)

    Segera Daftarkan Diri Anda dan Sobat-Sobatmu Untuk daftar bandarq terpercaya
    Bermain di Agen Poker Online Aktifqq di ID PRO PKV.
    Daftar sekarang juga dan menangkan jackpot jutaan
    rupiah setiap harinya Hanya di Aktifqq .

    Untuk info selengkapnya silahkan hubungi kami di :
    LIVECHAT WEBSITE
    WA : +85598746673
    LINK : Situs Taruhan Online Terbaik

    Agen Poker Terpercaya

  • Susah Menemukan SULTANPOKER Yang Aman Tanpa Robot/Admin??
    Segera Bergabung Dengan Kami Bagi Penggemar Poker Online..
    SultanPoker Situs Agen Judi Poker Online Terpercaya di Indonesia..
    Kepuasan Para Member Kami adalah Target dan Pencapaian Yang Kami Inginkan

    Kelebihan SultanPoker sebagai salah satu agen Bandar Poker dan Dominoqq online terpercaya Terbaik Se-Indonesia yaitu :
    1. Proses dana AMAN & CEPAT hanya 1 menit saja.
    2. 24 jam pelayanan CS yang ramah dan baik terhadap member.
    3. 100% FAIR PLAY tanpa adanya robot, admin ataupun kecurangan.
    4. Kerahasiaan member dijamin aman.
    5. Kemenangan Berapa pun Akan Kami Bayar !
    5. Bonus Refferal 20% [TERBESAR] [SEUMUR HIDUP]
    6. Bonus TurnOver 0,5% [TERBESAR][Setiap Hari]

    Games Yang Tersedia :
    1. Poker
    2. DominoQQ
    3. CEME
    4. CEME KELILING
    5. BLACKJACK
    6. Capsa Susun
    7. OMAHA ( Terbaru )
    8. Super10 ( Terbaru )

    Segera Daftarkan Diri Anda dan Sobat-Sobatmu Untuk daftar bandarq terpercaya
    Bermain di Agen Poker Online SULTANPOKER di ID IDNPOKER.
    Daftar sekarang juga dan menangkan jackpot jutaan
    rupiah setiap harinya Hanya di SULTANPOKER .

    Untuk info selengkapnya silahkan hubungi kami di :
    LIVECHAT WEBSITE
    WA : +85568301775
    LINK : BANDAR CEME