I have a dataframe with three Columns "Tasks, Instructions" and "len" (character length of Instructions).
I want to groupby the "Instructions" by "Tasks" and concatenate the rows of "Instructions" until next full stop (character) and up to a max of 100 characters per row.
For Example:
d = {'Tasks': ["TaskOne","TaskOne","TaskTwo","TaskTwo"], 'Instructions': ["longTextofInstructionsforTask1", "longTextofInstructionsforTask1","longTextofInstructionsforTask2 additional text", "longTextofInstructionsforTask2 additional text"]}
df = pd.DataFrame(data=d)
CURRENT DATAFRAME
Tasks Instructions len
0 TaskOne longTextofInstructionsforTask1 30
1 TaskOne longTextofInstructionsforTask1 30
2 TaskTwo longTextofInstructionsforTask2 additional text 46
3 TaskTwo longTextofInstructionsforTask2 additional text 46
DESIRED OUTCOME
Tasks Instructions len
0 TaskOne longTextofInstructionsforTask1 longTextofInstructionsforTask1 60
1 TaskTwo longTextofInstructionsforTask2 additional text longTextofInstructionsforTask2additional text 92