python Programming Glossary: pandas.dataframe

custom matplotlib plot : chess board like table with colored cells

http://stackoverflow.com/questions/10194482/custom-matplotlib-plot-chess-board-like-table-with-colored-cells

pandas from matplotlib.table import Table def main data pandas.DataFrame np.random.random 12 8 columns 'A' 'B' 'C' 'D' 'E' 'F' 'G' 'H'..

major memory problems reading in a csv file using numpy

http://stackoverflow.com/questions/10264739/major-memory-problems-reading-in-a-csv-file-using-numpy

data data.reshape 1 num_cols np.save filename data return pandas.DataFrame data This reads in the 2.5GB file and serializes the output..

Converting a Pandas GroupBy object to DataFrame

http://stackoverflow.com/questions/10373660/converting-a-pandas-groupby-object-to-dataframe

to DataFrame I'm starting with input data like this df1 pandas.DataFrame Name Alice Bob Mallory Mallory Bob Mallory City Seattle Seattle..

Interpolation on DataFrame in pandas

http://stackoverflow.com/questions/10464738/interpolation-on-dataframe-in-pandas

Series.interpolate to get a linear interpolation. In df pandas.DataFrame numpy.random.randn 5 3 index 'a' 'c' 'd' 'e' 'g' In df Out 0..

How to slice by columns in pandas

http://stackoverflow.com/questions/10665889/how-to-slice-by-columns-in-pandas

'mydata.csv' which gives something like data pandas.DataFrame np.random.rand 10 5 columns list 'abcde' I'd like to slice this..

add one row in a pandas.DataFrame

http://stackoverflow.com/questions/10715965/add-one-row-in-a-pandas-dataframe

one row in a pandas.DataFrame I understand that pandas is designed to load fully populated.. with different columns type Answer from @aix hint row pandas.DataFrame dict lib 'hello' qty1 4.0 qty2 100.0 res res.append row ignore_index..

NumPy or Pandas: Keeping array type as integer while having a NaN value

http://stackoverflow.com/questions/11548005/numpy-or-pandas-keeping-array-type-as-integer-while-having-a-nan-value

Things tried I tried using the from_records function under pandas.DataFrame with coerce_float False and this did not help. I also tried..

Selecting rows from a Pandas dataframe with a compound (hierarchical) index

http://stackoverflow.com/questions/11941492/selecting-rows-from-a-pandas-dataframe-with-a-compound-hierarchical-index

imagine we have the following dataframe import pandas df pandas.DataFrame 'group1' 'a' 'a' 'a' 'b' 'b' 'b' 'group2' 'c' 'c' 'd' 'd' 'd'..

Remove rows with duplicate indices (Pandas DataFrame and TimeSeries)

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

range 6 'B' range 6 data1 'A' 20 30 40 'B' 50 60 70 df1 pandas.DataFrame data data index index df2 pandas.DataFrame data data1 index.. 50 60 70 df1 pandas.DataFrame data data index index df2 pandas.DataFrame data data1 index index 3 df3 df1.append df2 df3 A B 2001 01..

Python Pandas: remove entries based on the number of occurrences

http://stackoverflow.com/questions/13446480/python-pandas-remove-entries-based-on-the-number-of-occurrences

.pid.transform len 1 import pandas import numpy as np data pandas.DataFrame 'pid' 1 1 1 2 2 3 3 3 'tag' 23 45 62 24 45 34 25 62 bytag data.groupby..

Aligning DataFrames with same columns, different index levels

http://stackoverflow.com/questions/13940753/aligning-dataframes-with-same-columns-different-index-levels

much luck stacking the dataframes and joining either wstk pandas.DataFrame weight.stack wstk.index.names 'Land Use' 'Basin' wstk.rename.. 'Basin' wstk.rename columns 0 'weight' inplace True cstk pandas.DataFrame concentration.stack cstk.index.names 'Land Use' 'Parameter'..

Compute a compounded return series in Python

http://stackoverflow.com/questions/5515021/compute-a-compounded-return-series-in-python

stored in something similar to a python dictionary see the pandas.DataFrame class ... then you access slices of the data as simply as close_prices..