-
Notifications
You must be signed in to change notification settings - Fork 0
/
csvReadWrite.py
69 lines (51 loc) · 2.21 KB
/
csvReadWrite.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<<<<<<< HEAD
import pandas as pd
import numpy as np
from pandas import DataFrame as df
import os
base_out_folder = r'C:\Users\ADMIN\Documents\PythonScripts\generalexamples\readCSV_produce_text\output'
base_in_folder = r'C:\Users\ADMIN\Documents\PythonScripts\generalexamples\readCSV_produce_text'
farm_names = ['Vanxx']
for thisFarm in farm_names:
start_index = 0
last_timestamp = 20190731
end_index = start_index+23
infilename = thisFarm+'.csv'
infilename = os.path.join(base_in_folder,infilename)
forecastDf = pd.read_csv(infilename)
forecastDf['forecast_2shift'] = forecastDf['forecast_2shift'].round(0)
while(end_index<=len(forecastDf)):
forecastSubDf = forecastDf.loc[start_index:end_index]
filename = str(last_timestamp) + '_XXX2_'+thisFarm+'.txt'
filename = os.path.join(base_out_folder,filename)
np.savetxt(filename, forecastSubDf.values, fmt='%d')
last_timestamp = str(forecastSubDf.loc[end_index,'time'])[0:8]
print last_timestamp
start_index = end_index+1
end_index = start_index+23
=======
import pandas as pd
import numpy as np
from pandas import DataFrame as df
import os
base_out_folder = r'C:\Users\ADMIN\Documents\PythonScripts\generalexamples\readCSV_produce_text\output'
base_in_folder = r'C:\Users\ADMIN\Documents\PythonScripts\generalexamples\readCSV_produce_text'
farm_names = ['Vanxx']
for thisFarm in farm_names:
start_index = 0
last_timestamp = 20190731
end_index = start_index+23
infilename = thisFarm+'.csv'
infilename = os.path.join(base_in_folder,infilename)
forecastDf = pd.read_csv(infilename)
forecastDf['forecast_2shift'] = forecastDf['forecast_2shift'].round(0)
while(end_index<=len(forecastDf)):
forecastSubDf = forecastDf.loc[start_index:end_index]
filename = str(last_timestamp) + '_XXX2_'+thisFarm+'.txt'
filename = os.path.join(base_out_folder,filename)
np.savetxt(filename, forecastSubDf.values, fmt='%d')
last_timestamp = str(forecastSubDf.loc[end_index,'time'])[0:8]
print last_timestamp
start_index = end_index+1
end_index = start_index+23
>>>>>>> 0cd77891ff432225a18e7c63bb358bc79d6816a0