Python Pandas 'str' object is not callable -


i new python , trying pandas library. here code read csv file without headers:

import pandas pnd import numpy np import matplotlib.pyplot plt import matplotlib mpl  pnd.set_option('max_columns', 50) mpl.rcparams['lines.linewidth'] = 2  headers = ['orderid', 'orderdate', 'userid', 'totalcharges'] dtypes = {'orderid': 'int', 'orderdate': 'str', 'userid': 'int', 'totalcharges':'float'} parse_dates = ['orderdate'] df = pnd.read_csv('raw_flight_data.csv', sep='\t', header=none,                   names=headers,converters=dtypes,parse_dates=parse_dates)

this code gives me error :-

runfile('c:/users/rohan.arora/desktop/python/example.py', wdir='c:/users/rohan.arora/desktop/python') traceback (most recent call last):    file "<ipython-input-47-43fc22883149>", line 1, in <module>     runfile('c:/users/rohan.arora/desktop/python/example.py', wdir='c:/users/rohan.arora/desktop/python')    file "c:\users\rohan.arora\anaconda2\lib\site-packages\spyder\utils\site\sitecustomize.py", line 866, in runfile     execfile(filename, namespace)    file "c:\users\rohan.arora\anaconda2\lib\site-packages\spyder\utils\site\sitecustomize.py", line 87, in execfile     exec(compile(scripttext, filename, 'exec'), glob, loc)    file "c:/users/rohan.arora/desktop/python/example.py", line 13, in <module>     names=headers,converters=dtypes,parse_dates=parse_dates)    file "c:\users\rohan.arora\anaconda2\lib\site-packages\pandas\io\parsers.py", line 646, in parser_f     return _read(filepath_or_buffer, kwds)    file "c:\users\rohan.arora\anaconda2\lib\site-packages\pandas\io\parsers.py", line 401, in _read     data = parser.read()    file "c:\users\rohan.arora\anaconda2\lib\site-packages\pandas\io\parsers.py", line 939, in read     ret = self._engine.read(nrows)    file "c:\users\rohan.arora\anaconda2\lib\site-packages\pandas\io\parsers.py", line 1508, in read     data = self._reader.read(nrows)    file "pandas\parser.pyx", line 848, in pandas.parser.textreader.read (pandas\parser.c:10415)    file "pandas\parser.pyx", line 870, in pandas.parser.textreader._read_low_memory (pandas\parser.c:10691)    file "pandas\parser.pyx", line 947, in pandas.parser.textreader._read_rows (pandas\parser.c:11728)    file "pandas\parser.pyx", line 1044, in pandas.parser.textreader._convert_column_data (pandas\parser.c:13129)    file "pandas\parser.pyx", line 2115, in pandas.parser._apply_converter (pandas\parser.c:28771)  typeerror: 'str' object not callable

i using anaconda spyder 3.1.2 , running python 2.7.13.

i think need remove ' types, not string representation of types:

dtypes = {'orderid': 'int', 'orderdate': 'str', 'userid': 'int', 'totalcharges':'float'}

to:

dtypes = {'orderid': int, 'orderdate': str, 'userid': int, 'totalcharges': float}

Comments

Post a Comment

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

consider, toml node module can use: // toml.d.ts declare module toml { export function parse(value:string):any; } declare module "toml" { export = toml; } then: /// <reference path="../../../../../defs/toml/toml.d.ts"/> import toml = require('toml'); toml.parse(...); however, node module export single function, such 'glob' ( https://github.com/isaacs/node-glob ). the node usage of module be: var glob = require("glob") glob("*.js", {}, callback(err, files) { ... }); you'd naively expect this: // glob.d.ts declare function globs(paths:string, options:any, callback:{(err:any, files:string[]):void; ...but because typescripts 'import' semantics bit strange, seems can use 'import .. = require()' statement alias modules . trying call: /// <reference path="../../../../../defs/glob/glob.d.ts"/> import blog = require('glob'); results in: error ts2072: mod
Read more

openid - Okta: Failed to get authorization code through API call -

i'm integrating okta own idp server using okta's api. i'm implementing authorization code flow following steps below: in own server, use /api/v1/authn endpoint sessiontoken. use sessiontoken obtain authorization calling endpoint: /oauth2/v1/authorize?client_id=" + clientid + "&sessiontoken=" + sessiontoken + "&response_type=code&response_mode=query&scope=openid&redirect_uri=" + redirecturl + "&state=evanyang&nonce=" it's supposed return response status code 302 , location header containing redirect url code value. however, keep getting response status code 200 , without location header, html body saying "you using unsupported browser." , "javascript disabled on browser." according api documentation: http://developer.okta.com/docs/api/resources/oidc.html#authentication-request , sessiontoken parameter sufficient this: an okta one-time sessiontoken. allows api-based
Read more

thorough guide for profiling racket code -

did googling ("racket profiling", "racket measure performance"), didn't find , there no examples in docs. did google "profile" search on htdp - no luck. (profile (f ...)) output isn't obvious other small snippets. ideally want python's python -m cprofile usage examples. when search "python profiling", both duckduckgo , google give top result: 26.4. python profilers . (although scanned quickly, seems more of reference "thorough usage guide" examples. if had else in mind, perhaps please link that?) the equivalent racket documentation be: profile: statistical profiler . a usage example: #lang racket (require profile) (profile-thunk (thunk (function-to-profile arg0 arg1) )) here (thunk e) convenience (lambda () e) . bigger example: #lang racket (module mod racket (provide f) (define (f) (for/list ([i 10000]) i))) (require (prefix-in mod: 'mod)) (define (f) (for ([i 10000
Read more