# Re: Problem in defining multidimensional array matrix and regression

On Sun, 19 Nov 2017, shalu.ash...@gmail.com wrote: >
Hi, All,
>
>I have 6 variables in CSV file. One is rainfall (dependent, at
>y-axis) and others are predictors (at x). I want to do multiple
>regression and create a correlation matrix between rainfall (y) and
>predictors (x; n1=5). Thus I want to read rainfall as a separate
>variable and others in separate columns, so I can apply the algo. However, I am
>not able to make a proper matrix for them.
>
>Here are my data and codes?
>Please suggest me for the same.
>I am new to Python.
>
>RF     P1      P2      P3      P4      P5
>120.235        0.234   -0.012  0.145   21.023  0.233
>200.14 0.512   -0.021  0.214   22.21   0.332
>185.362        0.147   -0.32   0.136   24.65   0.423
>201.895        0.002   -0.12   0.217   30.25   0.325
>165.235        0.256   0.001   0.22    31.245  0.552
>198.236        0.012   -0.362  0.215   32.25   0.333
>350.263        0.98    -0.85   0.321   38.412  0.411
>145.25 0.046   -0.36   0.147   39.256  0.872
>198.654        0.65    -0.45   0.224   40.235  0.652
>245.214        0.47    -0.325  0.311   26.356  0.632
>214.02 0.18    -0.012  0.242   22.01   0.745
>147.256        0.652   -0.785  0.311   18.256  0.924
>
>import numpy as np
>import statsmodels as sm
>import statsmodels.formula as smf
>import csv
>
>with open("pcp1.csv", "r") as csvfile:
>
>    rainfall = []
>    csvFileList = []
>
>    for row in readCSV:
>        Rain = row[0]
>        rainfall.append(Rain)
>
>        if len (row) !=0:
>            csvFileList = csvFileList + [row]
>
>print(csvFileList)
>print(rainfall)
>
>Please suggest me guys
>Thanks
>

There seems to be a conceptual disconnect here.
Do you happen to know what the letters C,S,V
stand for in CSV file?   Because I don't see any C's
in your data, and I don't see anything in your code
to use anything other than C to S your V's.

I'm thinking that is the first place you should look.
You could either modify your data file (with a nice global replace/change)
or you could give a different value to one of the default parameters
to the functions you use to open the file.

Roger Christman
Pennsylvania State University

--
https://mail.python.org/mailman/listinfo/python-list