I have a CSV file that contains 22, 000 rows of author names. Each row has multiple author names delimited by ';'. Each author name in a row is in 'lastName, firstName' order. I want to split them and append to new columns like shown below.
Below is a raw dataset preview:
+------------------------------------+
| author_full_name |
+------------------------------------+
| Kahana, M J; Adler, M |
|Gautam, H; Potdar, G G; Vidya, T N C|
+------------------------------------+
Below is the expected output of the above preview:
+------------------------------------+------------------------------------------+
| author_full_name | author_first_names| author_last_names |
+------------------------------------+------------------------------------------+
| Kahana, M J; Adler, M | M J; M | Kahana; Adler |
|Gautam, H; Potdar, G G; Vidya, T N C| H; G G; T N C | Gautam; Potdar; Vidya|
+------------------------------------+------------------------------------------+
How can I go about doing the same in pandas?