'Pandas function to convert a column (10,000 - 15,000) to either 2 separate columns or take the average value
This is the table I have extracted from the PDF. I want a column with either the average or split that into 2 separate columns.
Dataframe:
Solution 1:[1]
how about this ?
df['Amount'].str.split('-', 1, expand=True)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Daniel Weigel |