I need the indeces in analyzable format, i.e. csv, xls, from the year 2005 to 2015. The results are in HTML table/PDF format on the TI website. Can anyone link a source or write a script to scrape the data?

  • Can you give me a direct link to the HTML data? I need that before I can answer your question. Also, fiverr.com has freelancers that do a lot of data entry and data conversion. – Bulrush Apr 21 '16 at 12:09
  • Found it at https://github.com/datasets/corruption-perceptions-index. – rsl Apr 21 '16 at 12:13
  • I think you're going to have to do a bit of work on this one, or go to fiverr.com for help. – Bulrush Apr 21 '16 at 12:37
  • why don't you use the link you posted? its views as HTML but its csv – albert Apr 21 '16 at 13:27

In the Github link there is a file acquire_data.r. It has the exact URLs for datafiles from 2010 to 2015.

Inside those zip files are XLS files. I looked at one.

You can now copy and paste and assemble the data yourself. There are earlier years here. That will get you part of what you need.

For the earlier years I went to the 2009 webpage (http://www.transparency.org/research/cpi/cpi_2009/), I selected the table in my browser, and pasted the content into a text editor. From there it should be easy to save the text editor file to a .txt file, then import to Excel as comma-delimited. In the text editor data I pasted there are actually tabs between the columns, so it shouldn't be hard.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.