TGViewer
Data science/ML/AI Data science/ML/AI @datascience_bds · 14K subscribers
Post #1332 1.7K
📦 Your CSV Might Be Using Twice the Memory It Needs

Open a CSV in Pandas.

Run:
df.info()


You'll often notice many text columns have the type:
object


If a column contains repeated values like:
London
London
London
Paris
Paris
Berlin

convert it to:
category


Instead of storing the full text every time, Pandas stores each unique value once and references it internally.

On large datasets, memory usage can drop dramatically.
  • ❤ 4
  • 👍 2
More from @datascience_bds
  1. Oct 8, 2026document post
  2. Oct 7, 2026🧮 NumPy: Why axis=0 and axis=1 Feel Backwards You've probably seen: np.mean(X, axis=0) an…
  3. Oct 6, 2026document post
  4. Oct 5, 2026📊 Pandas Cheatsheet Every Data Analyst Should Save Pandas is one of the most important to…
  5. Oct 4, 2026SQLBolt: Interactive SQL You can learn SQL by writing real queries directly in the browser…
  6. Oct 3, 2026Tools vs MCP vs Skills: 3 Layers That Power Production AI Agents
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →