Home How to split multiple sentences and encase them in double quotes based on a period in python

Questions

How to split multiple sentences and encase them in double quotes based on a period in python

October 28, 2023

I have a dataframe with columns. In my pattern column, there are multiple sentences that end with a period. I need each sentence to have a have a double quote around it.

Below is the orignal text

patterns
Keep related supplies in the same area., Make an effort to clean a dedicated workspace after every session., Place loose supplies in large, clearly visible containers., Use clotheslines and clips to hang sketches, photos, and reference material., Use every inch of the room for storage, especially vertical space., Use chalkboard paint to make space for drafting ideas right on the walls., Purchase a label maker to make your organization strategy semi permanent., Make a habit of throwing out old, excess, or useless stuff each month.

patterns

Keep related supplies in the same area., Make an effort to clean a dedicated workspace after every session., Place loose supplies in large, clearly visible containers., Use clotheslines and clips to hang sketches, photos, and reference material., Use every inch of the room for storage, especially vertical space., Use chalkboard paint to make space for drafting ideas right on the walls., Purchase a label maker to make your organization strategy semi permanent., Make a habit of throwing out old, excess, or useless stuff each month.

I need the results to be:

patterns
"Keep related supplies in the same area.", "Make an effort to clean a dedicated workspace after every session.", "Place loose supplies in large, clearly visible containers.", "Use clotheslines and clips to hang sketches, photos, and reference material.", "Use every inch of the room for storage, especially vertical space.", "Use chalkboard paint to make space for drafting ideas right on the walls.", "Purchase a label maker to make your organization strategy semi permanent.", "Make a habit of throwing out old, excess, or useless stuff each month."

patterns

"Keep related supplies in the same area.", "Make an effort to clean a dedicated workspace after every session.", "Place loose supplies in large, clearly visible containers.", "Use clotheslines and clips to hang sketches, photos, and reference material.", "Use every inch of the room for storage, especially vertical space.", "Use chalkboard paint to make space for drafting ideas right on the walls.", "Purchase a label maker to make your organization strategy semi permanent.", "Make a habit of throwing out old, excess, or useless stuff each month."

What is did already,

df['patterns'] = df['patterns'].astype(str)

>Solution :

IIUC, you can do:

df["patterns"] = (
    df["patterns"]
    .str.findall(r"[A-Z].*?(?=,\s*[A-Z]|\Z)")
    .apply(lambda s: ", ".join(map(lambda s: f'"{s}"', s)))
)

Prints:

patterns
"Keep related supplies in the same area.", "Make an effort to clean a dedicated workspace after every session.", "Place loose supplies in large, clearly visible containers.", "Use clotheslines and clips to hang sketches, photos, and reference material.", "Use every inch of the room for storage, especially vertical space.", "Use chalkboard paint to make space for drafting ideas right on the walls.", "Purchase a label maker to make your organization strategy semi permanent.", "Make a habit of throwing out old, excess, or useless stuff each month."

patterns