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. |