nitin

San Francisco Bay Area

blog.kilotrader.com

2d
revised reading worksheet and preserving conditional formatting
deleted 10 characters in body
2d
comment Adding multiple rows to a DataFrame
Could you not work in numpy and add to an array (numpy.vstack) and then build the df from this array. I am not sure if it improves performance and memory footprint!
2d
asked reading worksheet and preserving conditional formatting
Feb
18
awarded Notable Question
Jan
21
comment Coloring Cells in Pandas
openpyxl is well maintained and has seen many recent update
Jan
19
awarded Popular Question
Jan
15
answered Vectorizing standard deviation calculations for pandas dataseries
Jan
15
comment Vectorizing standard deviation calculations for pandas dataseries
Thanks.. this is what I am looking for. I did a performance comparison between the two ways... there is 1000x improvement in performance.
Jan
15
accepted Vectorizing standard deviation calculations for pandas dataseries
Jan
15
asked Vectorizing standard deviation calculations for pandas dataseries
Jan
14
answered Convert a specific column into row names in Pandas
Jan
14
comment Efficiently reading .csv file containing tick-level fx data and converting it to OHLC data
pandas read_csv actually claims to be pretty fast. see..wesmckinney.com/blog/?p=543. I can't be sure, but it might have something to do with parse_dates. You might want to use parse_dates = [2] instead of True
Jan
3
awarded Tenacious
Dec
31
answered Multiply time series dataframe by series?
Dec
24
answered Selecting local minima and maxima from pandas.Series
Dec
23
comment resampling trade data into olhc format
Have you tried to do it without the 'how'
Dec
23
answered resampling trade data into olhc format
Dec
22
answered Unable to integrate over discrete set of points using Python
Dec
20
answered Vectorizing a function in pandas
Dec
19
comment Correcting cumulatives in Pandas
Do you have sample data (dataframe) for us to look at
1 2 3 4 5