Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Correlation Matrix Problem
#1
Alright, so I have a bunch of data from elections, one of the questions was to break the data down by state and look at the racial demographics (percentage of each race that makes up the state population) and compare that to the Republican Relative Vote for 2016 election. I have all of the data in a dataframe where the State acts as the index, it looks like this:

These are the column headings

White (Not Latino) Population : (percentage) for all races
African American Population
Native American Population
Asian American Population
Latino Population
White Asian
Other Race or Races
Republican Relative Vote 08 (decimal percentage)
Republican Relative Vote 12
Republican Relative Vote 16
ST : abbreviation for state


how do I create a correlation matrix from this?

I tried df.corr(), but it just gave me a matrix excluding all of the racial data. I need correlations between each race and the relative vote count, grouped by state.
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Matrix Calculation Problem arshad 4 149 Nov-04-2019, 03:48 PM
Last Post: baquerik
  Correlation of Incidents using time difference Rajhesh 1 178 Jun-27-2019, 03:44 PM
Last Post: Larz60+
  Correlation & Prediction - Help Danijel 2 742 Jul-12-2018, 11:08 PM
Last Post: Danijel
  matrix from matrix python numpy array shei7141 1 1,386 Jan-16-2017, 06:10 PM
Last Post: micseydel

Forum Jump:


Users browsing this thread: 1 Guest(s)