While you can do a lot with the functions in Excel or Google Sheets, as well as the plethora of data-related tools available, there comes a time when programming can help take your work to the next level.
So, as I said, I've done a little research to figure out what I should focus on. These are three programming languages I'm learning to aid my journalism.

A preview of the RStudio dashboard (Credit: Mararie, Flickr)
R
R has been increasing in popularity among data journalists over the last few years. It's easy to see why: whether you're collecting, cleaning or analysing data, R's a powerful tool that goes beyond what you can do in a spreadsheet.It's a constantly developing platform assisted by an active community of people willing to help you. With RStudio, there's a decent GUI in which to issue your commands that tell R what to do with the dataframe you input. Swirl is a good place to begin learning.
As the Data Journalism Handbook says:
It is hard to find any visualisation method or data wrangling technique that is not already built into R. R is a universe in its own, the mecca of visual data analysis. Trained data journalists can use R to analyze huge dataset which extends the limits of Excel.
SQL
Ever had two or more spreadsheets that you wanted to join together? Or a large dataset that you wanted to query? You quickly begin to see the restrictions with what you can do in a spreadsheet - which is where SQL comes in.The programming language allows you to do several things, including: selecting specific subsets of data that you want to extract; describing the exact changes you want to make; and performing queries across related datasets. You can save your commands as a script, meaning you can document your progress and repeat your steps in the future. Try the w3schools tutorial as a place to start.
Python
Among its many uses, Python is a language that you can use to scrape websites - more powerful than tools such as OutWit Hub. Python scripts can extract data from web pages and documents, allowing you to build datasets in which you can find strong stories.Gregor Aisch, of Open Knowledge Foundation, has said:
Python is a wonderful open source programming language which is easy to read and write (e.g. you don’t have to type a semi-colon after each line). More importantly, Python has a tremendous user base and therefore has plugins (called packages) for literally everything you need.
Once again, there are several tutorials out there to learn this language.
So there's my three: R, SQL and Python. Together they give you the skills to conduct great data journalism, from sourcing to scraping, from cleaning to visualising.
Got any more that you think I should include? Tweet me.
When assessing Web user experience, two major questions arise: what group of users will be studied, and what kind of data will be collected? The answers to these questions are interdependent, as well as dependent on the resources available to the researcher. See more quantitative data set
ReplyDeleteVery nice piece of information, please keep updating and share your valuable information with us.
ReplyDeletehtml5 training in chennai|html5 training chennai|html5 course in chennai|html5 training institutes in chennai
Many mistake HTML as a programming language but rather its a markup language and not progaramming language. HtML5 is the latest and technically most advanced version of HTML. To know more
ReplyDeletehtml5 training in chennai|html5 training chennai|html5 course in chennai
I appreciate the effort of the blogger. I have one small question which is related to html5. If you could help me out then it would be really helpful. How is the page structure in html5 is different from html4?
ReplyDeletehtml5 training in chennai|html5 course in chennai|html5 training institutes in chennai
I would like to learn SQL programming, where to start, what to write? can someone quickly advise forums or literature? thanks
ReplyDeleteDigital Marketing is one of the most promising field which is giving a tough tie for traditional marketing methods.
ReplyDeletedigital marketing course in chennai|Digital Marketing training in chennai|digital marketing courses in chennai
I really love reading and following your post as I find them extremely informative and interesting. This post is equally informative as well as interesting . web development
ReplyDeleteAngularJs is an open source framework which is used to add details to the website. AngularJs is supported by google which a major advantage to the developers.
ReplyDeleteRegards,
angularjs training in Chennai | angularjs training | FITA Academy reviews
Great post you could have completed the following. I'm truly happy to learn to read this kind of.Applications For Android This can be a very informative subject matter that you're picked. keep writing.
ReplyDeleteThe blog was absolutely fantastic! Lot of great information which can be helpful in some or the other way. Keep updating the blog, looking forward for more contents...Great job, keep it up..
ReplyDeleteWeb Design Bangalore
Nice blog. This is very useful post. Thanks for sharing.
ReplyDeleteInternet Marketing Company in chennai
Keep posting the good work. Some really helpful information in there. Bookmarked. Nice to see your site. click here
ReplyDeleteWonderful post. Thanks for sharing such a useful post.
ReplyDeleteWeb designing training in Chennai
Very useful content thanks for sharing such a informative content which provided me the required information on the various technology.
ReplyDeleteAngularJS Training in Chennai | AngularJS course in Chennai
Nice post. Best Selenium Training in Chennai |Selenium Training in Chennai |
ReplyDeleteAndroid Training in ChennaiBest Manual Testing Training in chennai
Nice informative content which provided me the required information about the programming language where i have gained lot of knowledge.
ReplyDeletePHP training in Chennai | PHP course in Chennai
Hibernate Online Training Hibernate Online Training Hibernate Training in Chennai Hibernate Training in Chennai Java Online Training Java Online Training
ReplyDeleteHibernate Training Institutes in ChennaiHibernate Training Institutes in Chennai Java Online Training Java Online Training
Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
ReplyDeleteWeb Designing Course in Chennai | web designing training in chennai
Thanks for the best topic. Very useful information.
ReplyDeleteVMWARE training in chennai
Word press is anything but difficult to develop and WordPress group has contributed hundreds of modules and topics to amplify its usefulness. Thanks for sharing this webpage. I learned a lot about WordPress. Keep sharing more like this.
ReplyDeleteRegards,
Wordpress Training in Chennai | Wordpress Training institutes in Chennai | Wordpress course in Chennai
This comment has been removed by the author.
ReplyDeleteWell Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
ReplyDeleteAngularjs training in chennai | Angularjs course in Chennai
Very useful post, Thanks for sharing this informative article and it's a worth read, your instruction is very clear.
ReplyDeleteIT Job Training (PHP Training in Chennai)
This comment has been removed by the author.
ReplyDeleteMarvelous blog with tons of valuable information. I gathered some useful information through your blog. Python Training | Data Science with Python Training
ReplyDeleteNice one..Android Training in Chennai | Best Android Training in Chennai | Best Android Training in Chennai with Placement
ReplyDeleteNice Blog to read
ReplyDeleteAndroid Training in Chennai | Best Android Training Institute in Chennaii | Best Android Training in Chennai with Placement
Useful post.Thanks forsharing.
ReplyDeleteAngularjs Training in Chennai | Angularjs Training Chennai