[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

pandas split and melt()

On 26/06/19 6:13 PM, Sayth Renshaw wrote:
> Hi
> Having fun with pandas filtering a work excel file.
> My current script opens selected and filters the data and saves as excel.

> This leaves me with a set of several columns. The main column of concern for this example is a consultant
> Session date	Consultant
> 2019-06-21 11:15:00	WNEWSKI, Joan;#17226;#BALIN, Jock;#18139;#DUNE, Colem;#17230;
> How can I split the consultant column, keep only names and drop the numbers and for every session date create a line with data and consultants name?
> NB. There are varied amounts of consultants so splitting across columns is uneven. if it was even melt seems like it would be good https://dfrieds.com/data-analysis/melt-unpivot-python-pandas

Keep it simple: https://docs.python.org/3.6/library/string.html

Regards =dn