Cannot write dataframe to a .csv file in python using file.write

Question

modified_symboltable = open('NYSE_Modified.csv', mode='w')

data1 = pd.DataFrame(pd.read_csv('NYSE_symbols.csv', sep=',', header='infer', index_col=None, usecols=[0, 1]))

print(data1)

modified_symboltable.write(str(data1))

Orignial data 'NYSE_symbols.csv' contains 3144 stock symbol data plus price data. What I want to do here is to isolate only symbols and names and write it to a different file for later use. But I cannot write everything on a 'modified_symboltable.csv', but instead it keeps writing the first 30 and the last 30 data only. What can I do here? I could not find any solution elsewhere. Many thanks

Not sure what you're trying to do, but you can just create a csv using data1.to_csv(file.csv). — cs95
– cs95, Commented Aug 5, 2017 at 7:24
Thanks.. Realized how noob I am... Such a simple solution there — SW Jeong
– SW Jeong, Commented Aug 5, 2017 at 7:27
Happy to help... we were all once the same. Anyways, feel free to mark my answer accepted when you can. — cs95
– cs95, Commented Aug 5, 2017 at 7:31

cs95 · Accepted Answer · 2017-08-05 07:27:01Z

1

Do not call str(df), it returns the string representation of the data frame, which is by default, the first and last 30 rows.
Do not write a dataframe to a file using file.write. There are easier ways.

Use df.to_csv instead.

data1.to_csv('NYSE_Modified.csv')

answered Aug 5, 2017 at 7:27

cs95

406k106 gold badges744 silver badges797 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot write dataframe to a .csv file in python using file.write

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related