Skip to main content

View Diary: Political geography: What if Appalachia were its own state? (166 comments)

Comment Preferences

  •  West Virginia is the only (1+ / 0-)
    Recommended by:
    Sylv

    state entirely present, so it still requires you to cut up states to get the data in one block (rather than adding up each county individually), something which I don't know how to do and was curious about. The same with how you added up the political calculations (excel)? The county data from Dave's is something you would have to copy down one at a time, 286 times for each race, and add up. Even copying that much data down to excel once is mindboggling to me, unless you are able to buy or procure that data already in excel form, and then easily make your calculations.

    Just looking at many of your diaries, I feel an anxiety attack building my chest as I estimate the sheer number of processes involved (yet wanted to do something similar), so I guess what I was curious about is that my estimates and my severely convoluted approximations of all the steps and calculations involved in a lot of these more ambitious projects are hopefully wrong and that there is a relatively streamlined or more simple process that I'm not seeing, which removes at least some of the repetition.

    "Once, many, many years ago I thought I was wrong. Of course it turned out I had been right all along. But I was wrong to have thought I was wrong." -John Foster Dulles. My Political Compass Score: -4.00, -3.69, Proud member of DKE

    by ArkDem14 on Tue Nov 19, 2013 at 11:24:35 PM PST

    [ Parent ]

    •  I used excel a lot to cut down on time (1+ / 0-)
      Recommended by:
      ArkDem14

      As for copying things from Leip's Atlas you can copy an entire state's worth of counties at once and I just set up a formula to convert that clunky format to something more useful. Then all I had to do was assign the counties to a new state, sort, subtotal, and voila, got the data. It only took a few hours total for all of them. Tracking down the census data, figuring out which counties to include, and making the maps is what took a while.

      •  I'm going to have to (0+ / 0-)

        message you sometime for a step by step guide to solving some problems I have. Hah.

        "Once, many, many years ago I thought I was wrong. Of course it turned out I had been right all along. But I was wrong to have thought I was wrong." -John Foster Dulles. My Political Compass Score: -4.00, -3.69, Proud member of DKE

        by ArkDem14 on Wed Nov 20, 2013 at 10:26:32 AM PST

        [ Parent ]

Subscribe or Donate to support Daily Kos.

Click here for the mobile view of the site