Panel

Constructor

Panel([data, items, major_axis, minor_axis, …]) (DEPRECATED) Represents wide format panel data, stored as 3-dimensional array.

Properties and underlying data

Axes

  • items: axis 0; each item corresponds to a DataFrame contained inside
  • major_axis: axis 1; the index (rows) of each of the DataFrames
  • minor_axis: axis 2; the columns of each of the DataFrames
Panel.values Return a Numpy representation of the DataFrame.
Panel.axes Return index label(s) of the internal NDFrame
Panel.ndim Return an int representing the number of axes / array dimensions.
Panel.size Return an int representing the number of elements in this object.
Panel.shape Return a tuple of axis dimensions
Panel.dtypes Return the dtypes in the DataFrame.
Panel.ftypes Return the ftypes (indication of sparse/dense and dtype) in DataFrame.
Panel.get_dtype_counts() Return counts of unique dtypes in this object.
Panel.get_ftype_counts() (DEPRECATED) Return counts of unique ftypes in this object.

Conversion

Panel.astype(dtype[, copy, errors]) Cast a pandas object to a specified dtype dtype.
Panel.copy([deep]) Make a copy of this object’s indices and data.
Panel.isna() Detect missing values.
Panel.notna() Detect existing (non-missing) values.

Getting and setting

Panel.get_value(*args, **kwargs) (DEPRECATED) Quickly retrieve single value at (item, major, minor) location.
Panel.set_value(*args, **kwargs) (DEPRECATED) Quickly set single value at (item, major, minor) location.

Indexing, iteration, slicing

Panel.at Access a single value for a row/column label pair.
Panel.iat Access a single value for a row/column pair by integer position.
Panel.loc Access a group of rows and columns by label(s) or a boolean array.
Panel.iloc Purely integer-location based indexing for selection by position.
Panel.__iter__() Iterate over infor axis
Panel.iteritems() Iterate over (label, values) on info axis
Panel.pop(item) Return item and drop from frame.
Panel.xs(key[, axis]) Return slice of panel along selected axis.
Panel.major_xs(key) Return slice of panel along major axis.
Panel.minor_xs(key) Return slice of panel along minor axis.

For more information on .at, .iat, .loc, and .iloc, see the indexing documentation.

Binary operator functions

Panel.add(other[, axis]) Addition of series and other, element-wise (binary operator add).
Panel.sub(other[, axis]) Subtraction of series and other, element-wise (binary operator sub).
Panel.mul(other[, axis]) Multiplication of series and other, element-wise (binary operator mul).
Panel.div(other[, axis]) Floating division of series and other, element-wise (binary operator truediv).
Panel.truediv(other[, axis]) Floating division of series and other, element-wise (binary operator truediv).
Panel.floordiv(other[, axis]) Integer division of series and other, element-wise (binary operator floordiv).
Panel.mod(other[, axis]) Modulo of series and other, element-wise (binary operator mod).
Panel.pow(other[, axis]) Exponential power of series and other, element-wise (binary operator pow).
Panel.radd(other[, axis]) Addition of series and other, element-wise (binary operator radd).
Panel.rsub(other[, axis]) Subtraction of series and other, element-wise (binary operator rsub).
Panel.rmul(other[, axis]) Multiplication of series and other, element-wise (binary operator rmul).
Panel.rdiv(other[, axis]) Floating division of series and other, element-wise (binary operator rtruediv).
Panel.rtruediv(other[, axis]) Floating division of series and other, element-wise (binary operator rtruediv).
Panel.rfloordiv(other[, axis]) Integer division of series and other, element-wise (binary operator rfloordiv).
Panel.rmod(other[, axis]) Modulo of series and other, element-wise (binary operator rmod).
Panel.rpow(other[, axis]) Exponential power of series and other, element-wise (binary operator rpow).
Panel.lt(other[, axis]) Wrapper for comparison method lt
Panel.gt(other[, axis]) Wrapper for comparison method gt
Panel.le(other[, axis]) Wrapper for comparison method le
Panel.ge(other[, axis]) Wrapper for comparison method ge
Panel.ne(other[, axis]) Wrapper for comparison method ne
Panel.eq(other[, axis]) Wrapper for comparison method eq

Function application, GroupBy

Panel.apply(func[, axis]) Applies function along axis (or axes) of the Panel.
Panel.groupby(function[, axis]) Group data on given axis, returning GroupBy object.

Computations / Descriptive Stats

Panel.abs() Return a Series/DataFrame with absolute numeric value of each element.
Panel.clip([lower, upper, axis, inplace]) Trim values at input threshold(s).
Panel.clip_lower(threshold[, axis, inplace]) (DEPRECATED) Trim values below a given threshold.
Panel.clip_upper(threshold[, axis, inplace]) (DEPRECATED) Trim values above a given threshold.
Panel.count([axis]) Return number of observations over requested axis.
Panel.cummax([axis, skipna]) Return cumulative maximum over a DataFrame or Series axis.
Panel.cummin([axis, skipna]) Return cumulative minimum over a DataFrame or Series axis.
Panel.cumprod([axis, skipna]) Return cumulative product over a DataFrame or Series axis.
Panel.cumsum([axis, skipna]) Return cumulative sum over a DataFrame or Series axis.
Panel.max([axis, skipna, level, numeric_only]) Return the maximum of the values for the requested axis.
Panel.mean([axis, skipna, level, numeric_only]) Return the mean of the values for the requested axis.
Panel.median([axis, skipna, level, numeric_only]) Return the median of the values for the requested axis.
Panel.min([axis, skipna, level, numeric_only]) Return the minimum of the values for the requested axis.
Panel.pct_change([periods, fill_method, …]) Percentage change between the current and a prior element.
Panel.prod([axis, skipna, level, …]) Return the product of the values for the requested axis.
Panel.sem([axis, skipna, level, ddof, …]) Return unbiased standard error of the mean over requested axis.
Panel.skew([axis, skipna, level, numeric_only]) Return unbiased skew over requested axis Normalized by N-1.
Panel.sum([axis, skipna, level, …]) Return the sum of the values for the requested axis.
Panel.std([axis, skipna, level, ddof, …]) Return sample standard deviation over requested axis.
Panel.var([axis, skipna, level, ddof, …]) Return unbiased variance over requested axis.

Reindexing / Selection / Label manipulation

Panel.add_prefix(prefix) Prefix labels with string prefix.
Panel.add_suffix(suffix) Suffix labels with string suffix.
Panel.drop([labels, axis, index, columns, …])
Panel.equals(other) Test whether two objects contain the same elements.
Panel.filter([items, like, regex, axis]) Subset rows or columns of dataframe according to labels in the specified index.
Panel.first(offset) Convenience method for subsetting initial periods of time series data based on a date offset.
Panel.last(offset) Convenience method for subsetting final periods of time series data based on a date offset.
Panel.reindex(*args, **kwargs) Conform Panel to new index with optional filling logic, placing NA/NaN in locations having no value in the previous index.
Panel.reindex_axis(labels[, axis, method, …]) (DEPRECATED) Conform input object to new index.
Panel.reindex_like(other[, method, copy, …]) Return an object with matching indices as other object.
Panel.rename([items, major_axis, minor_axis]) Alter axes input function or functions.
Panel.sample([n, frac, replace, weights, …]) Return a random sample of items from an axis of object.
Panel.select(crit[, axis]) (DEPRECATED) Return data corresponding to axis labels matching criteria.
Panel.take(indices[, axis, convert, is_copy]) Return the elements in the given positional indices along an axis.
Panel.truncate([before, after, axis, copy]) Truncate a Series or DataFrame before and after some index value.

Missing data handling

Panel.dropna([axis, how, inplace]) Drop 2D from panel, holding passed axis constant.

Reshaping, sorting, transposing

Panel.sort_index([axis, level, ascending, …]) Sort object by labels (along an axis)
Panel.swaplevel([i, j, axis]) Swap levels i and j in a MultiIndex on a particular axis
Panel.transpose(*args, **kwargs) Permute the dimensions of the Panel
Panel.swapaxes(axis1, axis2[, copy]) Interchange axes and swap values axes appropriately.
Panel.conform(frame[, axis]) Conform input DataFrame to align with chosen axis pair.

Combining / joining / merging

Panel.join(other[, how, lsuffix, rsuffix]) Join items with other Panel either on major and minor axes column.
Panel.update(other[, join, overwrite, …]) Modify Panel in place using non-NA values from other Panel.

Serialization / IO / Conversion

Panel.from_dict(data[, intersect, orient, dtype]) Construct Panel from dict of DataFrame objects.
Panel.to_pickle(path[, compression, protocol]) Pickle (serialize) object to file.
Panel.to_excel(path[, na_rep, engine]) Write each DataFrame in Panel to a separate excel sheet.
Panel.to_hdf(path_or_buf, key, **kwargs) Write the contained data to an HDF5 file using HDFStore.
Panel.to_sparse(*args, **kwargs) NOT IMPLEMENTED: do not call this method, as sparsifying is not supported for Panel objects and will raise an error.
Panel.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.
Panel.to_clipboard([excel, sep]) Copy object to the system clipboard.
Scroll To Top