Now you can data mine with Google queries too
Geek comic artist Randall Munroe, better known as XKCD’s creator, revealed a little-known Google Spreadsheets secret yesterday. You can plot out the estimated volume of Google search results against different queries.
How do you do it? Alex Chitu at Google Operating System says:
If you are familiar with Google Spreadsheets, try to create a sheet that lets you enter a query like “My IQ is X”, a variable name and the values for that variable. The result should be a graph that shows the number of Google search results for each instance of your query. Use importXML and an XPath expression to find the number of Google search results: “//p[@id='resultStats']/b[3]“. Here’s an example.
I’ve had a little fun this morning plotting out search queries against income. There’s not a distinctive trend though, aside from search results topping out at notable benchmarks like $100,000 and $1 million.
Next Story: Questions answered by your location history: Who were you with?
Previous Story: Yoichi Wada’s Final Fantasy: 96 million and counting
Companies: Google
People: randall munroe
About the Author, Kim-Mai Cutler
Kim-Mai was born and raised a stone's throw from Apple headquarters in Cupertino by a devout Hewlett-Packard family. After attending UC Berkeley, Kim-Mai worked for Bloomberg, The Wall Street Journal and Dow Jones Newswires in New York, Los Angeles, London and Buenos Aires. Follow her on Twitter at @kimmaicutler, and follow VentureBeat on Twitter at @venturebeat.
-
Ross
-
Nara R
