pandas.Panel

class pandas.Panel(data=None, items=None, major_axis=None, minor_axis=None, copy=False, dtype=None)

Represents wide format panel data, stored as 3-dimensional array.

Deprecated since version 0.20.0: The recommended way to represent 3-D data are with a MultiIndex on a DataFrame via the to_frame() method or with the xarray package. Pandas provides a to_xarray() method to automate this conversion.

Parameters:

data : ndarray (items x major x minor), or dict of DataFrames

items : Index or array-like

axis=0

major_axis : Index or array-like

axis=1

minor_axis : Index or array-like

axis=2

copy : boolean, default False

Copy data from inputs. Only affects DataFrame / 2d ndarray input

dtype : dtype, default None

Data type to force, otherwise infer

Attributes

at	Access a single value for a row/column label pair.
axes	Return index label(s) of the internal NDFrame
blocks	(DEPRECATED) Internal property, property synonym for as_blocks().
dtypes	Return the dtypes in the DataFrame.
empty	Indicator whether DataFrame is empty.
ftypes	Return the ftypes (indication of sparse/dense and dtype) in DataFrame.
iat	Access a single value for a row/column pair by integer position.
iloc	Purely integer-location based indexing for selection by position.
is_copy	Return the copy.
items
ix	A primarily label-location based indexer, with integer position fallback.
loc	Access a group of rows and columns by label(s) or a boolean array.
major_axis
minor_axis
ndim	Return an int representing the number of axes / array dimensions.
shape	Return a tuple of axis dimensions
size	Return an int representing the number of elements in this object.
values	Return a Numpy representation of the DataFrame.

timetuple

Methods

abs()	Return a Series/DataFrame with absolute numeric value of each element.
add(other[, axis])	Addition of series and other, element-wise (binary operator add).
add_prefix(prefix)	Prefix labels with string prefix.
add_suffix(suffix)	Suffix labels with string suffix.
align(other, **kwargs)	Align two objects on their axes with the specified join method for each axis Index.
all([axis, bool_only, skipna, level])	Return whether all elements are True, potentially over an axis.
any([axis, bool_only, skipna, level])	Return whether any element is True, potentially over an axis.
apply(func[, axis])	Applies function along axis (or axes) of the Panel.
as_blocks([copy])	(DEPRECATED) Convert the frame to a dict of dtype -> Constructor Types that each has a homogeneous dtype.
as_matrix()	Convert the frame to its Numpy-array representation.
asfreq(freq[, method, how, normalize, …])	Convert TimeSeries to specified frequency.
asof(where[, subset])	Return the last row(s) without any NaNs before where.
astype(dtype[, copy, errors])	Cast a pandas object to a specified dtype dtype.
at_time(time[, asof, axis])	Select values at particular time of day (e.g.
between_time(start_time, end_time[, …])	Select values between particular times of the day (e.g., 9:00-9:30 AM).
bfill([axis, inplace, limit, downcast])	Synonym for DataFrame.fillna() with method='bfill'.
bool()	Return the bool of a single element PandasObject.
clip([lower, upper, axis, inplace])	Trim values at input threshold(s).
clip_lower(threshold[, axis, inplace])	(DEPRECATED) Trim values below a given threshold.
clip_upper(threshold[, axis, inplace])	(DEPRECATED) Trim values above a given threshold.
compound([axis, skipna, level])	Return the compound percentage of the values for the requested axis.
conform(frame[, axis])	Conform input DataFrame to align with chosen axis pair.
convert_objects([convert_dates, …])	(DEPRECATED) Attempt to infer better dtype for object columns.
copy([deep])	Make a copy of this object’s indices and data.
count([axis])	Return number of observations over requested axis.
cummax([axis, skipna])	Return cumulative maximum over a DataFrame or Series axis.
cummin([axis, skipna])	Return cumulative minimum over a DataFrame or Series axis.
cumprod([axis, skipna])	Return cumulative product over a DataFrame or Series axis.
cumsum([axis, skipna])	Return cumulative sum over a DataFrame or Series axis.
describe([percentiles, include, exclude])	Generate descriptive statistics that summarize the central tendency, dispersion and shape of a dataset’s distribution, excluding NaN values.
div(other[, axis])	Floating division of series and other, element-wise (binary operator truediv).
divide(other[, axis])	Floating division of series and other, element-wise (binary operator truediv).
droplevel(level[, axis])	Return DataFrame with requested index / column level(s) removed.
dropna([axis, how, inplace])	Drop 2D from panel, holding passed axis constant.
eq(other[, axis])	Wrapper for comparison method eq
equals(other)	Test whether two objects contain the same elements.
ffill([axis, inplace, limit, downcast])	Synonym for DataFrame.fillna() with method='ffill'.
fillna([value, method, axis, inplace, …])	Fill NA/NaN values using the specified method.
filter([items, like, regex, axis])	Subset rows or columns of dataframe according to labels in the specified index.
first(offset)	Convenience method for subsetting initial periods of time series data based on a date offset.
first_valid_index()	Return index for first non-NA/null value.
floordiv(other[, axis])	Integer division of series and other, element-wise (binary operator floordiv).
fromDict(data[, intersect, orient, dtype])	Construct Panel from dict of DataFrame objects.
from_dict(data[, intersect, orient, dtype])	Construct Panel from dict of DataFrame objects.
ge(other[, axis])	Wrapper for comparison method ge
get(key[, default])	Get item from object for given key (DataFrame column, Panel slice, etc.).
get_dtype_counts()	Return counts of unique dtypes in this object.
get_ftype_counts()	(DEPRECATED) Return counts of unique ftypes in this object.
get_value(*args, **kwargs)	(DEPRECATED) Quickly retrieve single value at (item, major, minor) location.
get_values()	Return an ndarray after converting sparse values to dense.
groupby(function[, axis])	Group data on given axis, returning GroupBy object.
gt(other[, axis])	Wrapper for comparison method gt
head([n])	Return the first n rows.
infer_objects()	Attempt to infer better dtypes for object columns.
interpolate([method, axis, limit, inplace, …])	Interpolate values according to different methods.
isna()	Detect missing values.
isnull()	Detect missing values.
iteritems()	Iterate over (label, values) on info axis
join(other[, how, lsuffix, rsuffix])	Join items with other Panel either on major and minor axes column.
keys()	Get the ‘info axis’ (see Indexing for more)
kurt([axis, skipna, level, numeric_only])	Return unbiased kurtosis over requested axis using Fisher’s definition of kurtosis (kurtosis of normal == 0.0).
kurtosis([axis, skipna, level, numeric_only])	Return unbiased kurtosis over requested axis using Fisher’s definition of kurtosis (kurtosis of normal == 0.0).
last(offset)	Convenience method for subsetting final periods of time series data based on a date offset.
last_valid_index()	Return index for last non-NA/null value.
le(other[, axis])	Wrapper for comparison method le
lt(other[, axis])	Wrapper for comparison method lt
mad([axis, skipna, level])	Return the mean absolute deviation of the values for the requested axis.
major_xs(key)	Return slice of panel along major axis.
mask(cond[, other, inplace, axis, level, …])	Replace values where the condition is True.
max([axis, skipna, level, numeric_only])	Return the maximum of the values for the requested axis.
mean([axis, skipna, level, numeric_only])	Return the mean of the values for the requested axis.
median([axis, skipna, level, numeric_only])	Return the median of the values for the requested axis.
min([axis, skipna, level, numeric_only])	Return the minimum of the values for the requested axis.
minor_xs(key)	Return slice of panel along minor axis.
mod(other[, axis])	Modulo of series and other, element-wise (binary operator mod).
mul(other[, axis])	Multiplication of series and other, element-wise (binary operator mul).
multiply(other[, axis])	Multiplication of series and other, element-wise (binary operator mul).
ne(other[, axis])	Wrapper for comparison method ne
notna()	Detect existing (non-missing) values.
notnull()	Detect existing (non-missing) values.
pct_change([periods, fill_method, limit, freq])	Percentage change between the current and a prior element.
pipe(func, *args, **kwargs)	Apply func(self, *args, **kwargs).
pop(item)	Return item and drop from frame.
pow(other[, axis])	Exponential power of series and other, element-wise (binary operator pow).
prod([axis, skipna, level, numeric_only, …])	Return the product of the values for the requested axis.
product([axis, skipna, level, numeric_only, …])	Return the product of the values for the requested axis.
radd(other[, axis])	Addition of series and other, element-wise (binary operator radd).
rank([axis, method, numeric_only, …])	Compute numerical data ranks (1 through n) along axis.
rdiv(other[, axis])	Floating division of series and other, element-wise (binary operator rtruediv).
reindex(*args, **kwargs)	Conform Panel to new index with optional filling logic, placing NA/NaN in locations having no value in the previous index.
reindex_axis(labels[, axis, method, level, …])	(DEPRECATED) Conform input object to new index.
reindex_like(other[, method, copy, limit, …])	Return an object with matching indices as other object.
rename([items, major_axis, minor_axis])	Alter axes input function or functions.
rename_axis([mapper, index, columns, axis, …])	Set the name of the axis for the index or columns.
replace([to_replace, value, inplace, limit, …])	Replace values given in to_replace with value.
resample(rule[, how, axis, fill_method, …])	Resample time-series data.
rfloordiv(other[, axis])	Integer division of series and other, element-wise (binary operator rfloordiv).
rmod(other[, axis])	Modulo of series and other, element-wise (binary operator rmod).
rmul(other[, axis])	Multiplication of series and other, element-wise (binary operator rmul).
round([decimals])	Round each value in Panel to a specified number of decimal places.
rpow(other[, axis])	Exponential power of series and other, element-wise (binary operator rpow).
rsub(other[, axis])	Subtraction of series and other, element-wise (binary operator rsub).
rtruediv(other[, axis])	Floating division of series and other, element-wise (binary operator rtruediv).
sample([n, frac, replace, weights, …])	Return a random sample of items from an axis of object.
select(crit[, axis])	(DEPRECATED) Return data corresponding to axis labels matching criteria.
sem([axis, skipna, level, ddof, numeric_only])	Return unbiased standard error of the mean over requested axis.
set_axis(labels[, axis, inplace])	Assign desired index to given axis.
set_value(*args, **kwargs)	(DEPRECATED) Quickly set single value at (item, major, minor) location.
shift([periods, freq, axis])	Shift index by desired number of periods with an optional time freq.
skew([axis, skipna, level, numeric_only])	Return unbiased skew over requested axis Normalized by N-1.
slice_shift([periods, axis])	Equivalent to shift without copying data.
sort_index([axis, level, ascending, …])	Sort object by labels (along an axis)
sort_values(*args, **kwargs)	NOT IMPLEMENTED: do not call this method, as sorting values is not supported for Panel objects and will raise an error.
squeeze([axis])	Squeeze 1 dimensional axis objects into scalars.
std([axis, skipna, level, ddof, numeric_only])	Return sample standard deviation over requested axis.
sub(other[, axis])	Subtraction of series and other, element-wise (binary operator sub).
subtract(other[, axis])	Subtraction of series and other, element-wise (binary operator sub).
sum([axis, skipna, level, numeric_only, …])	Return the sum of the values for the requested axis.
swapaxes(axis1, axis2[, copy])	Interchange axes and swap values axes appropriately.
swaplevel([i, j, axis])	Swap levels i and j in a MultiIndex on a particular axis
tail([n])	Return the last n rows.
take(indices[, axis, convert, is_copy])	Return the elements in the given positional indices along an axis.
to_clipboard([excel, sep])	Copy object to the system clipboard.
to_csv([path_or_buf, sep, na_rep, …])	Write object to a comma-separated values (csv) file.
to_dense()	Return dense representation of NDFrame (as opposed to sparse).
to_excel(path[, na_rep, engine])	Write each DataFrame in Panel to a separate excel sheet.
to_frame([filter_observations])	Transform wide format into long (stacked) format as DataFrame whose columns are the Panel’s items and whose index is a MultiIndex formed of the Panel’s major and minor axes.
to_hdf(path_or_buf, key, **kwargs)	Write the contained data to an HDF5 file using HDFStore.
to_json([path_or_buf, orient, date_format, …])	Convert the object to a JSON string.
to_latex([buf, columns, col_space, header, …])	Render an object to a LaTeX tabular environment table.
to_msgpack([path_or_buf, encoding])	Serialize object to input file path using msgpack format.
to_pickle(path[, compression, protocol])	Pickle (serialize) object to file.
to_sparse(*args, **kwargs)	NOT IMPLEMENTED: do not call this method, as sparsifying is not supported for Panel objects and will raise an error.
to_sql(name, con[, schema, if_exists, …])	Write records stored in a DataFrame to a SQL database.
to_xarray()	Return an xarray object from the pandas object.
transform(func, *args, **kwargs)	Call func on self producing a NDFrame with transformed values and that has the same axis length as self.
transpose(*args, **kwargs)	Permute the dimensions of the Panel
truediv(other[, axis])	Floating division of series and other, element-wise (binary operator truediv).
truncate([before, after, axis, copy])	Truncate a Series or DataFrame before and after some index value.
tshift([periods, freq, axis])	Shift the time index, using the index’s frequency if available.
tz_convert(tz[, axis, level, copy])	Convert tz-aware axis to target time zone.
tz_localize(tz[, axis, level, copy, …])	Localize tz-naive index of a Series or DataFrame to target time zone.
update(other[, join, overwrite, …])	Modify Panel in place using non-NA values from other Panel.
var([axis, skipna, level, ddof, numeric_only])	Return unbiased variance over requested axis.
where(cond[, other, inplace, axis, level, …])	Replace values where the condition is False.
xs(key[, axis])	Return slice of panel along selected axis.

agg
aggregate
drop