OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.What it does: This popular jQuery plug-in (which was designed and created by Allan Jardine) creates sortable, searchable HTML tables from a variety of data sources - say, an existing, static HTML table, a JavaScript array, JSON or server-side SQL. Related tools: Google Refine is a desktop application that can do some rudimentary file analysis as well as its core task of data cleaning and The R Project for Statistical Computing can do more powerful statistical analysis on CSV and other files. There's also a brief introductory slide presentation that was given at the NICAR conference last month. Learn more: The documentation includes an easy-to-follow tutorial.
Runs on: Any Windows, Mac or Linux system with Python installed. Also, be advised that this tool suite is written in Python, so Windows users will need that installed on their system as well. The Unix-like interface will be familiar to anyone who has worked on a *nix system, and makes it easy to save multiple frequently used commands in a batch file.ĭrawbacks: Working on a command line means learning new text commands (not to mention the likely risk of typing errors), which might not be worthwhile unless you work with CSV files fairly often. CSVKit offers Unix-like command-line tools for importing, analyzing and reformatting comma-separated data files.
The SQL code will create a table, inferring the proper data type for each field as well as the insert commands for adding data to the table. Two simple commands will generate a data structure that can, in turn, be used by several SQL database formats ( Mr. In addition to inputting CSV files, it can import several fixed-width file formats - for example, there are libraries available for the specific fixed-width formats used by the Census Bureau and Federal Elections Commission. What's cool: Sure, you could pull your file into Excel to examine it, but CSVKit makes it quick and easy to preview, slice and summarize.įor example, you can see all your column headers in a list - which is handy for super-wide, many-column files - and then just pull data from a few of those columns. What it does: This utility suite available from Christopher Groskopf's GitHub account has a host of Unix-like command-line tools for importing, analyzing and reformatting comma-separated data files. Like that previous group of 22 tools, these range from easy enough for a beginner (i.e., anyone who can do rudimentary spreadsheet data entry) to expert (requiring hands-on coding).
Want to see all the tools from last year and 2012?įor quick reference, check out our chart listing all 30 free data visualization and analysis tools. At this year's conference, I learned about other free (or at least inexpensive) tools for data analysis and presentation. I came back from last year's National Institute for Computer-Assisted Reporting (NICAR) conference with 22 free tools for data visualization and analysis - most of which are still popular and worth a look. And, given the generally thrifty culture of your average newsroom, these tools often have the added appeal of little or no cost.
In fact, tools used by data-crunching journalists are generally useful for a wide range of other, non-journalistic tasks - and that includes software that's been specifically designed for newsroom use. Reporters wrangle all sorts of data, from analyzing property tax valuations to mapping fatal accidents - and, here at Computerworld, for stories about IT salaries and H-1B visas.