By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
    benefits of data analytics for financial industry
    Fascinating Changes Data Analytics Brings to Finance
    7 Min Read
    analyzing big data for its quality and value
    Use this Strategic Approach to Maximize Your Data’s Value
    6 Min Read
    data-driven seo for product pages
    6 Tips for Using Data Analytics for Product Page SEO
    11 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Google Squared a bit wobbly
Share
Notification Show More
Latest News
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
ai in ppc advertising
5 Proven Tips for Utilizing AI with PPC Advertising in 2023
Artificial Intelligence
data-driven image seo
Data Analytics Helps Marketers Substantially Boost Image SEO
Analytics
ai in web design
5 Ways AI Technology Has Disrupted Website Development
Artificial Intelligence
cloud-centric companies using network relocation
Cloud-Centric Companies Discover Benefits & Pitfalls of Network Relocation
Cloud Computing
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Visualization > Google Squared a bit wobbly
Data Visualization

Google Squared a bit wobbly

DavidMSmith
Last updated: 2009/06/04 at 6:32 PM
DavidMSmith
5 Min Read
SHARE
- Advertisement -

Google Labs has just released Google Squared. Unlike a Google web search which returns an unstructured list of web pages, Google Squared is designed to return structured data. Searching for US States returns a “square”, much like an Excel spreadsheet or a data frame in R.  The rows are states, and the columns are “facts” about those states: Name, Image, Population, etc. You can customize the columns returned to add new variables.

My first thought was that this would be a great source of data for examples in R. Just the other day, I was looking for a list the populations of the largest US cities to illustrate Zipf’s law — could Google Squared have helped me?  Sadly, no — at least not yet.

- Advertisement -
The first problem is data quality. That search for US States included Georgia in the top 10 … but if you add “Capital” to the list of variables, the capital is listed as T’bilisi, not Atlanta. To be fair, Google Squares lets you click on a data value and select from other possibilities, so I can change it to Atlanta if I want. But I was hoping that Google Squared would draw on the consensus of the Web, in context with my search, to produce a table of good data values. It seems the intent is to . …

More Read

data visualization for small business

Data Visualization Boosts Business Scalability with Sales Mapping

5 Best Practices for Extracting, Analyzing, and Visualizing Data
10 Important Ways Data Visualization Can Benefit Your Content Strategy
How to Bring Presentation Data to Life with Powered Template
From Raw Data to Visualization: Marvel Social Graph Analysis

Google Labs has just released Google Squared. Unlike a Google web search which returns an unstructured list of web pages, Google Squared is designed to return structured data. Searching for US States returns a “square”, much like an Excel spreadsheet or a data frame in R.  The rows are states, and the columns are “facts” about those states: Name, Image, Population, etc. You can customize the columns returned to add new variables.

My first thought was that this would be a great source of data for examples in R. Just the other day, I was looking for a list the populations of the largest US cities to illustrate Zipf’s law — could Google Squared have helped me?  Sadly, no — at least not yet.

The first problem is data quality. That search for US States included Georgia in the top 10 … but if you add “Capital” to the list of variables, the capital is listed as T’bilisi, not Atlanta. To be fair, Google Squares lets you click on a data value and select from other possibilities, so I can change it to Atlanta if I want. But I was hoping that Google Squared would draw on the consensus of the Web, in context with my search, to produce a table of good data values. It seems the intent is to use Google Squared as an alternative to Excel for collecting data you’ve found and verified yourself on the Web.

- Advertisement -
Even if you can find the right variables, getting the right records is tricky, too. Let’s say I want to generate data for the 50 US States. First of all, I have to keep clicking “Add next 10 items” until the Square is full of all 53 rows Google generates. (Why can’t I get all the rows in one fell swoop?) Then I have to delete DC, Virgin Islands, Afghanistan and Harvard University: that leaves me with 49 rows. One state is missing, but which one? You can’t sort the rows by state name, which might have helped.

My next thought was to export the Square to R, and match the names against state.name to find the missing one. But, alas, you can’t export the data. C’mon Google, why not a simple CSV export? I have to spend all this time creating and verifying the data, and now you’re not going to let me use it? Grr.

I know this is only a Labs feature, and it does show promise. But with the data quality issues and the inability to export, sadly it doesn’t seem like it’s going to be a useful source of datasets anytime soon.

Link to original post

DavidMSmith June 4, 2009
Share this Article
Facebook Twitter Pinterest LinkedIn
Share
- Advertisement -

Follow us on Facebook

Latest News

ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
ai in ppc advertising
5 Proven Tips for Utilizing AI with PPC Advertising in 2023
Artificial Intelligence
data-driven image seo
Data Analytics Helps Marketers Substantially Boost Image SEO
Analytics
ai in web design
5 Ways AI Technology Has Disrupted Website Development
Artificial Intelligence

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

data visualization for small business
Data Visualization

Data Visualization Boosts Business Scalability with Sales Mapping

7 Min Read
big data visualization
Data Visualization

5 Best Practices for Extracting, Analyzing, and Visualizing Data

6 Min Read
Data Visualization
Data Visualization

10 Important Ways Data Visualization Can Benefit Your Content Strategy

13 Min Read
Data Visualisation
Data Visualization

How to Bring Presentation Data to Life with Powered Template

8 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data
AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?