Here are 3 ways to convert a string to Pandas DataFrame based on how the string looks like:
(1) Multi-line string that contains the column names
import pandas as pd from io import StringIO my_string = """col_1,col_2,col_3 11,22,33 xx,yy,zz 4,5,6 """ data = StringIO(my_string) df = pd.read_csv(data, sep=",") print(df)
The string will be converted into Pandas DataFrame:
col_1 col_2 col_3
0 11 22 33
1 xx yy zz
2 4 5 6(2) Single-line string that contains the column names
import pandas as pd my_string = "col_1,col_2,col_3,11,22,33,xx,yy,zz,4,5,6" # Split the string based on a comma separator my_list = my_string.split(",") # Split the list into equally-sized chunks of three my_list_of_lists = [my_list[x:x + 3] for x in range(0, len(my_list), 3)] # Break the list of lists into the data without the columns, and just the columns list_of_lists_without_columns = my_list_of_lists[1:] list_columns = my_list_of_lists[0] # Create the DataFrame df = pd.DataFrame(list_of_lists_without_columns, columns=list_columns) print(df)
The result is the same DataFrame:
col_1 col_2 col_3
0 11 22 33
1 xx yy zz
2 4 5 6(3) Single-line string that does NOT contain the column names
import pandas as pd my_string = "11,22,33,xx,yy,zz,4,5,6" # Split the string based on a comma separator my_list = my_string.split(",") # Split the list into equally-sized chunks of three my_list_of_lists = [my_list[x:x + 3] for x in range(0, len(my_list), 3)] # Create a list of columns list_columns = ["col_1", "col_2", "col_3"] # Create the DataFrame df = pd.DataFrame(my_list_of_lists, columns=list_columns) print(df)
The result:
col_1 col_2 col_3
0 11 22 33
1 xx yy zz
2 4 5 6