How to split text to columns with Pandas and Python in a Jupyter Notebook

Documentation for splitting a text column into two columns in a Pandas DataFrame, with Python and Jupyter Notebook

Spreadsheet cowboys will know that a very common data cleaning operation is to split text to columns.

--

--

--

Documentation and tutorials on Python, Pandas, Jupyter Notebook, and Data Analysis.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Telling Compelling Data Stories on Mobile

Effectiveness of Minimax Group Fairness Algorithms

WiDS Abu Dhabi and Dubai 2020

Creating a Custom OpenAI Gym Environment for Stock Trading

Statistical Analysis Part 1: Box and Whisker Plot for Detecting Outliers

Can Multiple Linear Regression be Improved with Instance Level Statistics?

Data Catalog Benchmark for Mid-Market Companies

Modern Data Stack: which place for Spark ?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
David Allen

David Allen

Documentation and tutorials on Python, Pandas, Jupyter Notebook, and Data Analysis.

More from Medium

How to Batch Rename Columns in Pandas Based on Patterns

How to Analyse PowerBall Numbers with Python

Working with CSV files using Pandas