of an arbitrary size writing data out to text format data can also be exported to delimited format let' consider one of the csv files read abovein [ ]data pd read_csv('ch /ex csv'in [ ]data out[ ]something one two three nan message nan world foo using dataframe' to_csv methodwe can write the data out to comma-separated filein [ ]data to_csv('ch /out csv'in [ ]!cat ch /out csv ,something, , , , ,message ,one, , , , ,two, , ,, ,world ,three, , , , ,foo other delimiters can be usedof course (writing to sys stdout so it just prints the text result)in [ ]data to_csv(sys stdoutsep='|'|something| | | | |message |one| | | | |two| | || |world |three| | | | |foo missing values appear as empty strings in the output you might want to denote them by some other sentinel valuein [ ]data to_csv(sys stdoutna_rep='null',something, , , , ,message ,one, , , , ,null ,two, , ,null, ,world ,three, , , , ,foo with no other options specifiedboth the row and column labels are written both of these can be disabledin [ ]data to_csv(sys stdoutindex=falseheader=falseone, , , , two, , ,, ,world three, , , , ,foo you can also write only subset of the columnsand in an order of your choosing data loadingstorageand file formats www it-ebooks info