{"id":126769,"date":"2022-07-23T07:42:24","date_gmt":"2022-07-23T07:42:24","guid":{"rendered":"https:\/\/blog.finxter.com\/?p=505474"},"modified":"2022-07-23T07:42:24","modified_gmt":"2022-07-23T07:42:24","slug":"python-convert-string-to-csv-file","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2022\/07\/23\/python-convert-string-to-csv-file\/","title":{"rendered":"Python Convert String to CSV File"},"content":{"rendered":"\n
\n
\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n
5\/5 – (1 vote) <\/div>\n<\/div>\n

Problem Formulation<\/h2>\n

Given a Python string:<\/p>\n

my_string = '''a,b,c\n1,2,3\n9,8,7'''<\/pre>\n
\"\ud83d\udcac\" Question<\/strong>: How to convert the string to a CSV file in Python?<\/p>\n
The desired output is the CSV file:<\/p>\n
'my_file.csv'<\/strong><\/code>:<\/p>\n
a,b,c\n1,2,3\n9,8,7<\/code><\/pre>\n
Simple Vanilla Python Solution<\/h2>\n
To convert a multi-line string<\/a> with comma-separated values to a CSV file in Python, simply write the string in a file (e.g., with the name 'my_file.csv'<\/code>) without further modification. <\/p>\n
This works if the string is already in the correct CSV format with values separated by commas.<\/p>\n
The following code uses the open()<\/a><\/code> function and the file.write()<\/a><\/code> functions to write the multi-line string to a file without modification.<\/p>\n
my_string = '''a,b,c\n1,2,3\n9,8,7''' with open('my_file.csv', 'w') as out: out.write(my_string)\n<\/pre>\n
The result is a file 'my_file.csv'<\/code> with the following contents:<\/p>\n
a,b,c\n1,2,3\n9,8,7<\/code><\/pre>\n
Parsing and Modifying Text to CSV<\/h2>\n
The string may not be in the correct CSV format. <\/p>\n
For example, you may want to convert any of the following strings to a CSV file—their format is not yet ready for writing it directly in a comma-separated file (CSV):<\/p>\n
    \n
  1. Example 1<\/strong>: 'abc;123;987'<\/code><\/li>\n
  2. Example 2<\/strong>: 'abc 123 987'<\/code><\/li>\n
  3. Example 3<\/strong>: 'a=b=c 1=2=3 9=8=7'<\/code><\/li>\n
  4. …<\/li>\n<\/ol>\n
    To parse such a string and modify it before writing it in a file 'my_file.csv'<\/code>, you can use the string.replace()<\/a><\/code> and string.split()<\/a><\/code> methods to make sure that each value is separated by a comma and each row has its own line.<\/p>\n
    Let’s go over each of those examples to see how to parse the string effectively to bring it into the CSV format:<\/p>\n
    Example 1<\/h3>\n
    # Example 1:\nmy_string = 'abc;123;987' with open('my_file.csv', 'w') as out: lines = [','.join(line) for line in my_string.split(';')] my_string = '\\n'.join(lines) out.write(my_string)\n<\/pre>\n
    I’ve higlighted the two code lines that convert the string to the CSV format. <\/p>\n