Importing data in Spyder-Python

Question

I'm trying to import data (csv type) with Spyder (it has an Import Data option-green arrow, do you know what is this command by default?) and I get this error: 'NoneType' object has no attribute 'send'

Also, I have tried with numpy.genfromtxt("file.csv", delimiter = ',') and numpy.loadtxt("file.csv", delimiter = ',') but don't work. I am working with Python 3.2.3 and I use numpy and scipy (imported before execute the previuos commands).

Example of my datafile:

TIMESTAMP,TIMESTAMP,TIMESTAMP,TIMESTAMP,RECORD,Net_Shortwave_Avg (Wm-2),Net_Longwave_Avg(Wm-2),Net_Rad_Avg(Wm-2 )
12/21/2012 11:00:00,1100,12,11,0,556.0623,-131.1266,424.9357
12/21/2012 11:01:00,1101,12,11,1,564.877,-132.1396,432.7373

I don't have a code yet because I need to import the data first and I have tried with the above commands, numpy.genfromtxt and numpy.loadtxt — D.MerBet
– D.MerBet, Commented Sep 4, 2013 at 20:37
I don't know, that message just appear when I'm trying to import the data with the Import Data option of Spyder — D.MerBet
– D.MerBet, Commented Sep 4, 2013 at 20:43
Can you post a sample of your datafile? Then we can figure out why loadtxt doesn't work. It should work for a simple csv file. — DanHickstein
– DanHickstein, Commented Sep 4, 2013 at 22:48

DanHickstein · Accepted Answer · 2013-09-05 01:01:57Z

1

The loadtxt function, by default, tries to convert everything to a float. It is getting confused by the text in the header and the datetime objects in the first column. You can tell it how to use the datetime objects, and you can also have it read the header. However, the simplest thing to do is to tell loadtxt to ignore the first row and the first column, like this:

data = np.loadtxt('data.csv',delimiter=',',usecols=range(1,7),skiprows=1)

It might also be convenient to unpack you data into separate variables, like this (I'm kinda guessing what some of the fields are):

day,hour,minute,Net_Shortwave_Avg,Net_Longwave_Avg,Net_Rad_Avg =  np.loadtxt('data.csv',delimiter=',',usecols=range(1,7),skiprows=1,unpack=True)

answered Sep 5, 2013 at 1:01

DanHickstein

6,96814 gold badges61 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Importing data in Spyder-Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related