python - "pandas.io.common.EmptyDataError: No columns to parse from file" after moving to mac -


in windows 8, script works fine. after moved script , data.csv work in mac, keep getting error: "pandas.io.common.emptydataerror: no columns parse file."

the script , data in same folder 

"/users/myname/downloads/test/testimport.py" "/users/myname/downloads/test/test2.csv"

i've tried many file locations read csv nothing works.

file_loc = "../test/test2.csv" # "../test2.csv", "/test2.csv", "/users/myname/downloads/test/test2.csv"  import pandas pd df = pd.read_csv(file_loc) exp_mat = df.as_matrix() print exp_mat

how can read csv here? wrong location problem or csv filetype in mac not compatible?

here os x ei capitan. full error is

h143% python testimport.py traceback (most recent call last):   file "test_importexcel.py", line 24, in <module>     df = pd.read_csv(file_loc)   file "/users/myname/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 646, in parser_f     return _read(filepath_or_buffer, kwds)   file "/users/myname/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 389, in _read     parser = textfilereader(filepath_or_buffer, **kwds)   file "/users/myname/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 730, in __init__     self._make_engine(self.engine)   file "/users/myname/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 923, in _make_engine self._engine = cparserwrapper(self.f, **self.options)   file "/users/myname/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 1390, in __init__ self._reader = _parser.textreader(src, **kwds)   file "pandas/parser.pyx", line 538, in pandas.parser.textreader.__cinit__ (pandas/parser.c:6171) pandas.io.common.emptydataerror: no columns parse file

data (copying number like)

x   time    value 445.1207    0.003626    21935450 445.1203    0.011099    36700932 445.1203    0.017235    35722172 445.1203    0.022958    33623668 445.1203    0.028689    33500360 352.3396    37.180567   307886720 352.3396    37.185836   303264100 352.3396    37.191101   292523810


Comments

Post a Comment

Popular posts from this blog

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

java - How to implement an entity bound odata action in olingo v4.3 -

similar post, i'm trying implement action bound entity how create bounded action in olingo v4 (java) but 500 no error logged when metadata document. in answer above linked question, there no mention of getactionimport() implementation described in olingo tutorial, , wonder if needs modified entity-bound action? how can olingo log error causing 500? getting debug output quite easy: handler.register(new defaultdebugsupport()); where handler odatahttphandler armed this, , after examination of olingo-server-core code, discovered: you don't need actionimport @ bound actions. the action name in url needs qualified namespace, https://issues.oasis-open.org/browse/odata-812 has not been implemented. when built client url using org.apache.olingo.client.api.uri.uribuilder , wrapped entity id in single quotes, , olingo server threw exception, reverted using stringbuilder
Read more