OT Has anybody brought this info into excel, SPSS, SAS, csv, etc.?

[Art Kendall]

Has anybody brought this info into excel, SPSS, SAS, csv, etc.?

http://en.wikipedia.org/wiki/List_of_U.S._states_and_territories_by_population

If so, would you send it to me?
===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Andy W]

FYI a good tool for this is google docs, you can use the import html tables function to pull data from wikipedia. Caveat Emptor using wikipedia and all that jazz.

If you just use this function in google docs it will bring in the table you want;

=ImportHtml("http://en.wikipedia.org/wiki/List_of_U.S._states_and_territories_by_population","table",3)

The table can be seen here. Attached is the spreadsheet. You can see some funny business with importing the rank and the electors numbers (if you look at the source you will see those are the actual numbers in the table, not sure why that is). It shouldn't be too difficult an exercise though to clean the data (just import as strings and do some text munging).

I know Excel has similar functionality, but trying with Excel 03 it wasn't allowing me to select that particular table. I know a python extension to import data from the internet was available, but I believe it doesn't import html tables like this (just grabs actual files that can be read directly in SPSS I believe).

Wikipedia_US_States_-_Sheet1.csv

[Garry Gelade]

Art

 

You can just highlight the cells of the table; right click; copy, and paste direct into Excel.

 

You’ll probably then want to remove the icons and tidy a bit, but it works just fine for me.

 

Garry

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Art Kendall
Sent: 30 October 2012 12:57
To: [hidden email]
Subject: OT Has anybody brought this info into excel, SPSS, SAS, csv, etc.?

 

Has anybody brought this info into excel, SPSS, SAS, csv, etc.?

http://en.wikipedia.org/wiki/List_of_U.S._states_and_territories_by_population

If so, would you send it to me?

--

Art Kendall

Social Research Consultants

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Art Kendall]

Garry was right. Thanks Garry.
 My mistake when i tried to highlight-cut-paste was that I included the headers.




On 10/30/2012 12:47 PM, Garry Gelade wrote:

Art

 

You can just highlight the cells of the table; right click; copy, and paste direct into Excel.

 

You’ll probably then want to remove the icons and tidy a bit, but it works just fine for me.

 

Garry

 

 

From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Art Kendall
Sent: 30 October 2012 12:57
To: [hidden email]
Subject: OT Has anybody brought this info into excel, SPSS, SAS, csv, etc.?

 

Has anybody brought this info into excel, SPSS, SAS, csv, etc.?

http://en.wikipedia.org/wiki/List_of_U.S._states_and_territories_by_population

If so, would you send it to me?

--

Art Kendall

Social Research Consultants

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Dean Howlin]

I am out of the office untill 11am 31st October. Please contact my colleagues Niall or Stephen if you need assistance.

[hidden email];[hidden email]

 

[Andy W]

Very cool, thanks for sharing this Art (and for the copy-paste Garry!) When I was at home copying and pasting worked out of the box for both SPSS (V20) and Excel (2010).

At work for my ancient software, Excel 2003 did not parse the data correctly and copied all of the contents to one cell. SPSS (V15) did however recognize the different values, but one needed to initialize the fields to strings though, or otherwise the fields were treated as numeric by default and so any field without numeric data was treated as missing.

Include map images in your posts Art! It will be good to have more examples floating around of what SPSS can do with its recent map additions.

Andy