Python -cvs vs txt

from matplotlib import pyplot as plt
from matplotlib import style
import pandas as pd
import csv #python內建

style.use('ggplot')
#txt轉成csv
#讀取數據
txtPath = '/users/jht/Desktop/python/stockData/2330.txt'
readTxt = csv.reader(open(txtPath,'r'),delimiter=',')#以','符號定界分行delimiter
#匯入並創建csv檔案
cvsPath = '/users/jht/Desktop/python/stockData/2330.csv'
writeCsv = csv.writer(open(cvsPath,'w'))
writeCsv.writerow(['NO','price'])#設定row heaer
writeCsv.writerows(readTxt)#匯入txt
x=[]
y=[]
with open(txtPath,'r') as txt2330: #以r唯讀,打開檔案,呼叫用txt2330
plots = csv.reader(txt2330,delimiter=',')
for row in plots:
x.append(float(row[0]))
y.append(float(row[1]))
plt.subplot(211)
plt.plot(x,y)

plt.subplot(212)
data = pd.read_csv(cvsPath, parse_dates=True, index_col='NO')#以parse_dates判定x,y個數相等
print(data.head())
plt.plot(data['price'],label='price',color='b')
plt.legend()

plt.show()


Comments

Popular posts from this blog

Go-VSCode -Autocomplete and Auto-import

Go - mail