Converting strings in rows of a Pandas Dataframe into characters separated by commas

Question

Converting strings in rows of a Pandas Dataframe into characters separated by commas

I am dealing with a dataframe that has sequence data in each row, formatted like this.

MKEYGEDLK

My goal is to process the sequence strings in each row to have them presented in this format:

[M, K, E, Y, G, E, D, L, K]

I attempted the following code:

get_seq_str = ','.join(test_df.loc[0]['seq_1'])
arr.append(get_seq_str)

However, when I add it to the dataframe, there are single quotation marks at the beginning and end of each string which I want to remove.

[M, K, E, Y, G, E, D, L, K]

Is there a way to strip these single quotation marks?

python python-3.x pandas

Answer 1

Answer №1

As I understand it, one approach you can take is using the apply method with the list function on a string value.

df['col_list'] = df['col'].apply(list)

print(df)

         col                     col_list
0  MKEYGEDLK  [M, K, E, Y, G, E, D, L, K]

Answer 2

As I understand it, one approach you can take is using the apply method with the list function on a string value.

df['col_list'] = df['col'].apply(list)

print(df)

         col                     col_list
0  MKEYGEDLK  [M, K, E, Y, G, E, D, L, K]

Answer 3

Answer №2

To extract individual characters from a string in a DataFrame column, you can utilize the str.findall method:

df['new_column'] = df['original_column'].str.findall(r'[a-zA-Z]')

For example:

         original_column              new_column
0    MKEYGEDLK             [M, K, E, Y, G, E, D, L, K]
1  ?MKEY GEDLK           [M, K, E, Y, G, E, D, L, K]

Answer 4

To extract individual characters from a string in a DataFrame column, you can utilize the str.findall method:

df['new_column'] = df['original_column'].str.findall(r'[a-zA-Z]')

For example:

         original_column              new_column
0    MKEYGEDLK             [M, K, E, Y, G, E, D, L, K]
1  ?MKEY GEDLK           [M, K, E, Y, G, E, D, L, K]

Answer 5

Answer №3

Here is one way to achieve the desired result:

sequence_string = [*sample_data_frame.iloc[0]['sequence_1']]

Answer 6

Here is one way to achieve the desired result:

sequence_string = [*sample_data_frame.iloc[0]['sequence_1']]

Converting strings in rows of a Pandas Dataframe into characters separated by commas

Answer №1

Answer №2

Answer №3

Similar questions

Is there compatibility for Python 3 in nolearn/lasagne?

Experimenting with FastAPI's TestClient results in a 422 response code for specific

What could be causing my web scraper to not extract the necessary data?

I have a pair of pyspark dataframes and I am looking to compute the total sum of points in the second dataframe, which will be based on the

Linking a function to multiple labels with the same name - tkinter

Tips for preserving a collection of items in a thesaurus?

A guide on combining elements within a list of lists

Python code to find all combinations of pairs for a given function's values

Automate page scrolling using Python and Selenium

Transferring cookie data between requests in CrawlSpider

Python code for arranging the output in numerical sequence

The saving of data in the session is not working as expected

Locate a Sub-Child href Element using Selenium

How can I implement a waiting mechanism for the loading g-loading-icon on Google's People Also Ask feature using Selenium and Python?

Sending a post request with a PIL Image in Python

Creating a matrix or table in Python to analyze overlapping data frames and count the intersections

Python code: Transforming points on a contour into a bounding box

Unlocking the secrets of password-protected website scraping

Using Selenium and Python to showcase the source of an image within an iframe

Saving a Python pandas dataframe to a CSV file with line breaks represented as text