pandas indexing issue (original) (raw)

in 0.12

ex_date Unnamed: 0 asset_type cusip name shares value form_type accepted period company_name cik sec_id end_date

0 2002-11-08 00:00:00 0 COM 281020107 EDISON INTERNATI 2792500 27925000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 N03TRC-S-US 2002-11-08 00:00:00

4 2002-11-08 00:00:00 4 COM 453235103 INAMED CORPCOM 3669359 84395000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 M89FLH-S-US 2002-11-08 00:00:00

5 2002-11-08 00:00:00 5 COM 494580103 KINDRED HEALTHCA 2475427 91665000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 P7KT40-S-US 2002-11-08 00:00:00

6 2002-11-08 00:00:00 6 042006 494580111 KINDRED HEALTHCA 720398 5064000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 TXX3S4-S-US 2002-11-08 00:00:00

7 2002-11-08 00:00:00 7 042006 494580129 KINDRED HEALTHCA 1800996 6664000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 QDX491-S-US 2002-11-08 00:00:00

ex_date Unnamed: 0 asset_type cusip name shares value form_type accepted period company_name cik sec_id end_date portfolio_rank

0 2002-11-08 00:00:00 0 COM 281020107 EDISON INTERNATI 2792500 27925000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 N03TRC-S-US 2002-11-08 00:00:00 3

4 2002-11-08 00:00:00 4 COM 453235103 INAMED CORPCOM 3669359 84395000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 M89FLH-S-US 2002-11-08 00:00:00 2

5 2002-11-08 00:00:00 5 COM 494580103 KINDRED HEALTHCA 2475427 91665000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 P7KT40-S-US 2002-11-08 00:00:00 1

6 2002-11-08 00:00:00 6 042006 494580111 KINDRED HEALTHCA 720398 5064000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 TXX3S4-S-US 2002-11-08 00:00:00 7

7 2002-11-08 00:00:00 7 042006 494580129 KINDRED HEALTHCA 1800996 6664000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00 APPALOOSA MANAGEMENT LP 0001006438 QDX491-S-US 2002-11-08 00:00:00 6

in 0.13:

ex_date Unnamed: 0 asset_type cusip name \

0 2002-11-08 00:00:00 0 COM 281020107 EDISON INTERNATI

4 2002-11-08 00:00:00 4 COM 453235103 INAMED CORPCOM

5 2002-11-08 00:00:00 5 COM 494580103 KINDRED HEALTHCA

6 2002-11-08 00:00:00 6 042006 494580111 KINDRED HEALTHCA

7 2002-11-08 00:00:00 7 042006 494580129 KINDRED HEALTHCA

shares value form_type accepted period \

0 2792500 27925000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00

4 3669359 84395000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00

5 2475427 91665000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00

6 720398 5064000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00

7 1800996 6664000 13F-HR 2002-11-08 00:00:00 2002-09-30 00:00:00

company_name cik sec_id end_date

0 APPALOOSA MANAGEMENT LP 0001006438 N03TRC-S-US 2002-11-08 00:00:00

4 APPALOOSA MANAGEMENT LP 0001006438 M89FLH-S-US 2002-11-08 00:00:00

5 APPALOOSA MANAGEMENT LP 0001006438 P7KT40-S-US 2002-11-08 00:00:00

6 APPALOOSA MANAGEMENT LP 0001006438 TXX3S4-S-US 2002-11-08 00:00:00

7 APPALOOSA MANAGEMENT LP 0001006438 QDX491-S-US 2002-11-08 00:00:00

[5 rows x 14 columns]

Traceback (most recent call last):

File "test_form_data.py", line 201, in

z = get_form13_performance(cik, form_13_store, 10)

File "test_form_data.py", line 103, in get_form13_performance

cik_df["portfolio_rank"] = cik_df.groupby("ex_date")["value"].transform(lambda x: x.rank(ascending=False))

File "/local/install/pandas_test/lib/python2.7/site-packages/pandas/core/groupby.py", line 1824, in transform

result.iloc[self.indices[name]] = res

KeyError: Timestamp('2002-11-08 00:00:00', tz=None)

Closing remaining open files: /data/form13/form13.h5... done