Features. Gephi is a tool for data analysts and scientists keen to explore and understand graphs. Like Photoshop™ but for graph data, the user interacts with the representation, manipulate the structures, shapes and colors to reveal hidden patterns. The goal is to help data analysts to make hypothesis, intuitively discover patterns, isolate structure singularities or faults during data sourcing. It is a complementary tool to traditional statistics, as visual thinking with interactive interfaces is now recognized to facilitate reasoning. This is a software for Exploratory Data Analysis, a paradigm appeared in the Visual Analytics field of research.
Real-time visualization Profit from the fastest graph visualization engine to speed-up understanding and pattern discovery in large graphs. Layout Layout algorithms give the shape to the graph. Metrics The statistics and metrics framework offer the most common metrics for social network analysis (SNA) and scale-free networks. Networks over time Input/Output.
Dipity - Find, Create, and Embed Interactive Timelines. Infogr.am. Datawrapper. Pocketbook2012.pdf (application/pdf Object) World Databank. Opendata & données publiques. Données publiques / Open Data. FRANCE - Espérance de vie par départements. Public Data Explorer. Tableaux de l'Économie Française - Édition 2012. International Programs - Region Summary. Processing Request Frequently Asked Questions (FAQ) 1.
What is the International Data Base? The International Data Base (IDB) offers a variety of demographic indicators for countries and areas of the world with a population of 5,000 or more. The IDB has provided access to demographic data for over 25 years to governments, academics, other organizations, and the public. 2. The IDB provides many types of demographic data, including: · Estimates and projections of: o Birth, death, and growth rates, migration rates, infant mortality, and life expectancy o Fertility rates o Total population and population by age and sex 3. The following ZIP file contains the complete data set which has currently been released and is used by the International Data Base tool. 4.
The demographic estimates and projections found in the International Data Base are the result of over 30 years of analysis of census, survey, vital statistics, and other data by Census Bureau demographers. 5. 6. 7. 8. 9. Tableau Public. Google-refine. Creating A Database Table From A Summary Table. Category: General | [Item URL] Many users are familiar with Excel's pivot table feature, which creates a summary table from a database table.
But what if you want to perform the opposite operation? This document describes how to create a database table from a simple two-variable summary table. The worksheet below demonstrates. Range A1:E13 contains the original summary table, and columns G:I shows a 48-row database table derived from the summary table. How to do it The solution to creating this "reverse pivot table" is to use a pivot table! Part 1: Creating a pivot table Activate any cell in your summary table Choose Data - PivotTable and PivotChart Report (the menu command may vary, depending on the version of Excel). Part 2: Finishing up At this point, you will have a small pivot table that shows only the sum of all values: Double-click the cell that contains the total (outlined in yellow, above).
A VBA Macro to do it Excel Tips All Tips Browse Tips by Category Search for Tips Tip Books. Data exploration tutorial with google refine. Recently, Hugh Stimson published a great article: Data Mining My Old Radio Playlists.
His post mix tutorials on php scripting, data cleaning with google refine and data analysis with PostgreSQL. This answer post demonstrate that data analysis is fully doable in google refine using really basic function (I'll be using GREL function only once for the long tail analysis). I guess also this post is a good illustration of my previous post on data exploration using google refine. Count number of play by episode and title To determine the unique number of different episode, in google refine, facet the episodename column, facet > text facet.
For this one I used two different facet on the title column. Facet > customized facet > facet by blank (at the bottom of the drop down list) Blog Archive » Data-Mining My Old Radio Playlists. In which I scrape all my old radio playlists off the web, cook them with Python, Google Refine and PostgreSQL, and discover that I played one heck of a long tail of songs.
And J.J. Cale. A friend from the Ann Arbor years was in town for a conference, and it put me in mind of my radio days. After every show I used to post up a link to the playlist automatically generated by the WCBN server. Like this for example. I was wondering that, and I also happen to have a lot of idle time at night while I’m on sleeping-baby-monitoring duty. Scraping the Webpages with Python The first step was to actually get all that data from the web, preferably in some more data-like format than raw HTML.
Python has built in capabilities for connecting to a website and getting the HTML, but navigating the raw HTML tags for useful info sounds like a terrible idea.