Specify RG metadata column dtype on read
The column "metro_id" is usually mixed dtype, which is slower to read. Set it as str.
@@ -309,7 +309,7 @@ class Table:
cache = columns is None
read_columns = None if cache else columns
if self.format == "csv":
- df = pd.read_csv(self.path, usecols=read_columns)
+ df = pd.read_csv(self.path, usecols=read_columns, dtype={"metro_id": str})
elif self.format == "parquet":
df = self._dataset.read(columns=read_columns).to_pandas()
if cache:
