Search code examples
pythonpysparkapache-spark-sqlazure-databricks

Split file based on \r into new rows


I have an csv file in my source folder, want to get the output as new line where we have "\r"

Source File \name\age\gender\r\kiran\29\male\r\rekha\12\female\r\siva\39\male\r

Expected output file

\name\age\gender

\kiran\29\male

\rekha\12\female

\siva\39\male


Solution

  • with open('filename.csv', 'r+') as file:
        data = file.readlines()[0].replace(('\\r\\','\n\\'))[:-1]
    
    print(data)
    

    enter image description here