Message Boards Message Boards

How to use expected total number alive today on many names?

Posted 10 years ago

Okay I would love any and all help;

I have been using Wolfram Alpha to find the estimated number of people with different names in the united states and it has been working great. However, now I need to find the expected number of people alive with over a thousand different names for a project I am working on. Is there anyway to input the names and get this process automated or do I need to do this one at a time?

POSTED BY: Tyler Wallace
7 Replies
POSTED BY: David Reiss
Posted 10 years ago
POSTED BY: Tyler Wallace
Posted 10 years ago
Attachments:
POSTED BY: Tyler Wallace
Attachments:
POSTED BY: David Reiss

If you post your excel file to this form, I can show you how to do this. However I may not be able to get to it until late tomorrow or early the next day. Though it is possible that somebody else will pick up on this thread and show you.

POSTED BY: David Reiss
Posted 10 years ago
POSTED BY: Tyler Wallace

It is not clear how to (or whether it is possible to) get Wolfram|Alpha to return data for that large a dataset of names. However, in Mathematica one can request the data for a particular name using, with "Alphonse" as an example,

EntityValue[Entity["GivenName", {"Alphonse", "UnitedStates", "male"}], 
   EntityProperty["GivenName", "GivenNameTotal"]]

so this can easily be converted to a function that can be mapped onto a list of names of any given length.

POSTED BY: David Reiss
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract