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 over requested 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]) | The last row without any NaN is taken (or the last row without NaN considering only the subset of columns in the case of a DataFrame) |
astype(dtype[, copy, errors]) | Cast a pandas object to a specified dtype dtype. |
at_time(time[, asof]) | 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(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]) | Return copy of the input with values below a threshold truncated. |
clip_upper(threshold[, axis, inplace]) | Return copy of input with values above given value(s) truncated. |
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. |
consolidate([inplace]) | (DEPRECATED) Compute NDFrame with “consolidated” internals (data of each dtype grouped together in a single ndarray). |
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]) | Generates 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). |
dropna([axis, how, inplace]) | Drop 2D from panel, holding passed axis constant |
eq(other[, axis]) | Wrapper for comparison method eq |
equals(other) | Determines if two NDFrame objects contain the same elements. |
ffill([axis, inplace, limit, downcast]) | Synonym for DataFrame.fillna(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, …]) | Return an object of same shape as self and whose corresponding entries are from self where cond is False and otherwise are from other. |
max([axis, skipna, level, numeric_only]) | This method returns the maximum of the values in the object. |
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]) | This method returns the minimum of the values in the object. |
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, …]) | Conform input object to new index with optional filling logic, placing NA/NaN in locations having no value in the previous index. |
reindex_like(other[, method, copy, limit, …]) | Return an object with matching indices to myself. |
rename([items, major_axis, minor_axis]) | Alter axes input function or functions. |
rename_axis(mapper[, axis, copy, inplace]) | Alter the name of the index or columns. |
replace([to_replace, value, inplace, limit, …]) | Replace values given in to_replace with value. |
resample(rule[, how, axis, fill_method, …]) | Convenience method for frequency conversion and resampling of time series. |
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([by, axis, ascending, inplace, …]) | NOT IMPLEMENTED: do not call this method, as sorting values is not supported for Panel objects and will raise an error. |
squeeze([axis]) | Squeeze length 1 dimensions. |
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_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 tabular environment table. |
to_msgpack([path_or_buf, encoding]) | msgpack (serialize) object to input file path |
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. |
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, ambiguous]) | Localize tz-naive TimeSeries to target time zone. |
update(other[, join, overwrite, …]) | Modify Panel in place using non-NA values from passed Panel, or object coercible to Panel. |
var([axis, skipna, level, ddof, numeric_only]) | Return unbiased variance over requested axis. |
where(cond[, other, inplace, axis, level, …]) | Return an object of same shape as self and whose corresponding entries are from self where cond is True and otherwise are from other. |
xs(key[, axis]) | Return slice of panel along selected axis |