Group Abstract

Message Boards

WOLFRAM COMMUNITY

6.2K Views

4 Replies

0 Total Likes

View groups...

Follow this post

Share this post:

GROUPS:

Import and Export Wolfram|Alpha Integration

Get University Population Data

Rob Leitzell

Posted 5 years ago

I have a CSV file of different universities, and I would like to query Wolfram Pro to get information about population statistics at these universities. Although I can do so easily from the search bar, I struggle to have it analyze a CSV document and return the tabular information. Can someone direct me to some assistance on this, I'm having a hard time googling around for it. Many thanks, Rob

POSTED BY: Rob Leitzell

4 Replies

Sort By:

Rohit Namjoshi

Posted 5 years ago

I have never used Wolfram Pro so I am not sure if this is possible or not. Maybe someone else can give a better answer. It is quite easy to do this using WL in Mathematica. universityNames = Import["~/Downloads/Number of Students.csv", {"Data", 2 ;; , 1}] // Map[StringSplit[#, {"(", "--"}] & /* First /* StringTrim] {#, WolframAlpha[#, {{"Enrollment:UniversityData", 1}, "ComputableData"}][[1]]} & /@ universityNames Part of the output { {"Air Force Institute of Technology", "NotAvailable"}, {"Binghamton University", {"all students", Quantity[17768, "People"]}}, {"Davidson College", {"all students", Quantity[1843, "People"]}}, {"Delaware State University", {"all students", Quantity[4586, "People"]}}, {"Florida Atlantic University", {"all students", Quantity[29772, "People"]}}, {"Florida Institute of Technology", {"all students", Quantity[6271, "People"]}}, {"Franklin and Marshall College", {"all students", Quantity[2309, "People"]}} }

I have never used Wolfram Pro so I am not sure if this is possible or not. Maybe someone else can give a better answer.

It is quite easy to do this using WL in Mathematica.

universityNames = Import["~/Downloads/Number of Students.csv", {"Data", 2 ;; , 1}] // 
  Map[StringSplit[#, {"(", "--"}] & /* First /* StringTrim]

{#, WolframAlpha[#, {{"Enrollment:UniversityData", 1}, "ComputableData"}][[1]]} & /@
  universityNames

Part of the output

{
 {"Air Force Institute of Technology", "NotAvailable"},
 {"Binghamton University", {"all students", Quantity[17768, "People"]}},
 {"Davidson College", {"all students", Quantity[1843, "People"]}},
 {"Delaware State University", {"all students", Quantity[4586, "People"]}},
 {"Florida Atlantic University", {"all students", Quantity[29772, "People"]}},
 {"Florida Institute of Technology", {"all students", Quantity[6271, "People"]}},
 {"Franklin and Marshall College", {"all students", Quantity[2309, "People"]}}
 }

POSTED BY: Rohit Namjoshi

Rob Leitzell

Posted 5 years ago

Yes, thanks so much for your assistance. For instance, if I search for "Number of students at Franklin and Marshall COllege", I get: 2309 people (according to 2018-19 school year estimates). But I'd like to upload a CSV and get back values for each university in the CSV, as per attached. Is this possible? Attachments: Number of Students 2.csv Number of Students.csv