python Programming Glossary: pivot

Remove rows with duplicate indices (Pandas DataFrame and TimeSeries)

http://stackoverflow.com/questions/13035764/remove-rows-with-duplicate-indices-pandas-dataframe-and-timeseries

but I am stuck on figuring out the group_by or pivot or statements to make that work. update Per an answer I tried..

http://stackoverflow.com/questions/15570099/pandas-pivot-tables-row-subtotals

stA ctA 20 400 1000 stA ctB 30 500 1100 I tried with a pivot table but i only can have subtotals in columns table pivot_table.. pivot table but i only can have subtotals in columns table pivot_table df values 'SalesToday' 'SalesMTD' 'SalesYTD' rows 'State'.. np.sum margins True I can achieve this on excel with a pivot table. python pandas pivot table share improve this question..

Extracting XML into data frame with parent attribute as column title

http://stackoverflow.com/questions/16991691/extracting-xml-into-data-frame-with-parent-attribute-as-column-title

it to your requirements. Then you're looking for a pivot In 11 df Out 11 child Time grandchild 0 blah 1200 100 1 blah.. 1300 30 2 abc 1200 2 3 abc 1300 4 4 abc 1400 2 In 12 df.pivot 'Time' 'child' 'grandchild' Out 12 child abc blah Time 1200..

python - create a pivot table

http://stackoverflow.com/questions/17028329/python-create-a-pivot-table

create a pivot table I'm trying to create a pivot table from a Numpy array.. create a pivot table I'm trying to create a pivot table from a Numpy array in python. I've done a lot of research.. 11 96 ... 89205 16 146 89205 17 154 89205 18 244 I need a pivot table where the rows are the first column the columns are the..