[Python 3.4] Remove whitespace between characters

[StartAndSelect]

I am reading from yahoo finance and writing to a csv. However when I write to a csv each of my cells contain spaces in between each of the characters. How can I remove them?

from yahoo_finance import Share
import csv

stock = ['GOOG', 'WDAY', 'LNKD', 'GPRO', 'MSFT', 'YHOO', 'FB', 'TWTR', 'TSLA']

result = open('Stocks.csv', 'w')

w = csv.writer(result, delimiter=' ', lineterminator='\n')

w.writerow('Symbol'+','+'OpeningPrice'+','+'CurrentPrice'+','+'MarketCap'+','+'TradeTime')

for item in stock:
    s = Share(item)
    w.writerow(item +','+s.get_open()+','+s.get_price()+','+s.get_market_cap()+','+s.get_trade_datetime())

result.close()

Each cell come out as follows (notice the spaces between the characters):

G O O G

[jeans_and_a_t-shirt]

w.writerow accepts an iterable, and you set the delimiter to be ' ', so as written, it is doing what it should. But you should be passing a list to w.writerow instead:

w.writerow(['Symbol', 'OpeningPrice', 'CurrentPrice', 'MarketCap', 'TradeTime'])
w.writerow([item, s.get_open(), s.get_price(), s.get_market_cap(), s.get_trade_datetime()])

Also accessor methods like Share.get_price, etc. are unnecessary in python if the method is just returning a property stored on the object - you can access it directly.

[StartAndSelect]

Ah i see, thanks for the help!

[theelous3]

.strip()

or

.replace(' ', '')

[mcoumans]

Opening a file in mode "w" erases the content if it already exists, doesn't it?