| data type | description | supports missing values |
|---|---|---|
| float | The NumPy float type | Yes |
| int | The NumPy integer type | No |
| 'Int64' | pandas nullable integer type | Yes |
| object | The NumPy type for storing strings (and mixed types) | |
| 'category' | pandas categorical type | Yes |
| bool | The NumPy Boolean type | No. None becomes False, np.nan becomes True. |
| 'boolean' | pandas nullable Boolean type | Yes |
| datetime64[ns] | The NumPy date type | Yes (NaT) |
Ref:- (Pandas 1.x Cookbook, by Matt Harrison and Theodore Petrou, second edition, published in 2020) → Chapter 1 → page-7
Sample code to generate EmptyDataError exception
>>> import pandas as pd >>> from io import StringIO >>> empty = StringIO() >>> pd.read_csv(empty) Traceback (most recent call last): ... pandas.errors.EmptyDataError: No columns to parse from file
Ref: https://pandas.pydata.org/pandas-docs/dev/reference/api/pandas.errors.EmptyDataError.html - Got the initial version of the code from here.
Instead of
pandas.io.common.EmptyDataError
use
pandas.errors.EmptyDataError
data point | as of pandas 1.1.2, pandas.io.common.EmptyDataError does not work.
Ref:-
We are adding a standard public module for all pandas exceptions & warnings pandas.errors. (GH14800). Previously these exceptions & warnings could be imported from pandas.core.common or pandas.io.common. These exceptions and warnings will be removed from the *.common locations in a future release. (GH15541)
Instead of
from pandas.util.testing import assert_frame_equal
use
from pandas.testing import assert_frame_equal
data point:
Using from pandas.util.testing import assert_frame_equal in pandas 1.1.2, I get
FutureWarning: pandas.util.testing is deprecated. Use the functions in the public API at pandas.testing instead.