从特定日期开始按数字除以列 [英] divide the column by number start from certain date
问题描述
大家好
我下面的数据为例
< item>,< date>,< open>,< high>,< low>,< close>,< val< br/>
DATATWO,20091123,34.10,34.70,33.90,34.00,183864
DATATWO,20091122,34.00,34.10,33.90,34.10,60365
DATATWO,20091121,34.00,34.20,34.00,34.00,51884
DATATWO,20091118,34.20,34.30,34.10,34.20,115571
DATATWO,20091117,34.30,34.60,34.00,34.20,516206
DATATWO,20091116,34.10,35.00,34.00,34.10,162858
DATATWO,20091115,34.20,34.20,33.90,33.90,75410
DATATWO,20091114,34.00,34.10,34.00,34.00,28933
DATATWO,20091111,33.80,34.20,33.60,34.00,65898
DATATWO,20091110,34.20,34.20,33.90,33.90,71228
DATATWO,20091109,34.60,34.60,33.90,34.00,198851
DATATWO,20091108,35.00,35.00,34.40,34.50,114733
DATATWO,20091107,35.20,35.20,34.60,34.90,66236
DATATWO,20091104,35.40,35.50,35.20,35.20,82450
DATATWO,20091103,35.70,35.70,35.40,35.40,40061
DATATWO,20091102,35.90,35.90,35.50,35.70,90958
DATATWO,20091101,35.60,35.80,35.60,35.70,14165
DATATWO,20091031,35.80,36.00,35.60,35.70,71073
DATATWO,20091028,37.00,37.00,36.60,36.60,77966
DATATWO,20091027,37.20,37.20,36.80,37.00,113719
DATATWO,20091026,37.40,37.80,37.10,37.10,158274
DATATWO,20091025,37.80,37.80,37.30,37.40,89968
DATATWO,20091024,37.60,38.00,37.20,37.80,54023
DATATWO,20091021,37.00,38.00,36.80,37.90,214118
DATATWO,20091020,37.20,37.40,37.10,37.20,101335
DATATWO,20091019,37.10,37.40,37.00,37.20,171211
DATATWO,20091018,37.60,37.60,37.10,37.40,34278
ONEDATA,20091123,25.80,25.80,25.50,25.60,242422
ONEDATA,20091122,25.50,25.80,25.30,25.50,196910
ONEDATA,20091121,25.50,26.30,25.00,25.50,414786
ONEDATA,20091118,26.40,26.40,25.60,25.60,440876
ONEDATA,20091117,26.80,27.00,26.40,26.40,628506
ONEDATA,20091116,26.50,26.90,26.10,26.80,771484
ONEDATA,20091115,27.10,27.30,26.10,26.50,1376046
ONEDATA,20091114,25.60,27.00,25.50,26.80,1979906
ONEDATA,20091111,25.00,25.80,25.00,25.40,528152
ONEDATA,20091110,25.90,26.00,25.30,25.40,388478
ONEDATA,20091109,25.80,26.40,25.50,25.60,874960
ONEDATA,20091108,25.10,25.80,24.70,25.80,1008774
ONEDATA,20091107,25.30,25.50,25.10,25.30,958518
ONEDATA,20091104,25.30,25.60,24.95,25.00,559368
ONEDATA,20091103,25.80,25.90,24.95,24.95,403726
ONEDATA,20091102,26.00,26.00,25.50,25.80,365698
ONEDATA,20091101,24.75,26.30,24.75,26.00,888482
ONEDATA,20091031,25.10,26.10,24.75,24.95,879178
ONEDATA,20091028,26.30,26.40,25.80,26.00,351332
ONEDATA,20091027,26.90,26.90,26.30,26.30,374670
ONEDATA,20091026,26.90,27.10,26.50,27.00,394278
ONEDATA,20091025,27.40,27.50,26.80,26.90,487238
ONEDATA,20091024,27.30,27.80,26.90,27.50,335160
ONEDATA,20091021,27.00,27.30,26.00,27.10,1294626
ONEDATA,20091020,27.80,27.90,27.00,27.10,337172
ONEDATA,20091019,28.80,28.90,27.60,27.80,944246
ONEDATA,20091018,28.50,30.40,28.00,28.30,1652822
< p>如何对< item>的列进行除数(< open>,< high>,< low>,< close>,< val>). (DATATWO)从特定日期开始,例如(DATATWO,20091121,34.00,34.20,34.00,34.00,51884)&gob下降
仅适用于DATATWO
谢谢
这是csv/txt文件数据吗?
hi all
I have the data below as example
<item>,<thedate>,<open>,<high>,<low>,<close>,<val>
DATATWO,20091123,34.10,34.70,33.90,34.00,183864
DATATWO,20091122,34.00,34.10,33.90,34.10,60365
DATATWO,20091121,34.00,34.20,34.00,34.00,51884
DATATWO,20091118,34.20,34.30,34.10,34.20,115571
DATATWO,20091117,34.30,34.60,34.00,34.20,516206
DATATWO,20091116,34.10,35.00,34.00,34.10,162858
DATATWO,20091115,34.20,34.20,33.90,33.90,75410
DATATWO,20091114,34.00,34.10,34.00,34.00,28933
DATATWO,20091111,33.80,34.20,33.60,34.00,65898
DATATWO,20091110,34.20,34.20,33.90,33.90,71228
DATATWO,20091109,34.60,34.60,33.90,34.00,198851
DATATWO,20091108,35.00,35.00,34.40,34.50,114733
DATATWO,20091107,35.20,35.20,34.60,34.90,66236
DATATWO,20091104,35.40,35.50,35.20,35.20,82450
DATATWO,20091103,35.70,35.70,35.40,35.40,40061
DATATWO,20091102,35.90,35.90,35.50,35.70,90958
DATATWO,20091101,35.60,35.80,35.60,35.70,14165
DATATWO,20091031,35.80,36.00,35.60,35.70,71073
DATATWO,20091028,37.00,37.00,36.60,36.60,77966
DATATWO,20091027,37.20,37.20,36.80,37.00,113719
DATATWO,20091026,37.40,37.80,37.10,37.10,158274
DATATWO,20091025,37.80,37.80,37.30,37.40,89968
DATATWO,20091024,37.60,38.00,37.20,37.80,54023
DATATWO,20091021,37.00,38.00,36.80,37.90,214118
DATATWO,20091020,37.20,37.40,37.10,37.20,101335
DATATWO,20091019,37.10,37.40,37.00,37.20,171211
DATATWO,20091018,37.60,37.60,37.10,37.40,34278
ONEDATA,20091123,25.80,25.80,25.50,25.60,242422
ONEDATA,20091122,25.50,25.80,25.30,25.50,196910
ONEDATA,20091121,25.50,26.30,25.00,25.50,414786
ONEDATA,20091118,26.40,26.40,25.60,25.60,440876
ONEDATA,20091117,26.80,27.00,26.40,26.40,628506
ONEDATA,20091116,26.50,26.90,26.10,26.80,771484
ONEDATA,20091115,27.10,27.30,26.10,26.50,1376046
ONEDATA,20091114,25.60,27.00,25.50,26.80,1979906
ONEDATA,20091111,25.00,25.80,25.00,25.40,528152
ONEDATA,20091110,25.90,26.00,25.30,25.40,388478
ONEDATA,20091109,25.80,26.40,25.50,25.60,874960
ONEDATA,20091108,25.10,25.80,24.70,25.80,1008774
ONEDATA,20091107,25.30,25.50,25.10,25.30,958518
ONEDATA,20091104,25.30,25.60,24.95,25.00,559368
ONEDATA,20091103,25.80,25.90,24.95,24.95,403726
ONEDATA,20091102,26.00,26.00,25.50,25.80,365698
ONEDATA,20091101,24.75,26.30,24.75,26.00,888482
ONEDATA,20091031,25.10,26.10,24.75,24.95,879178
ONEDATA,20091028,26.30,26.40,25.80,26.00,351332
ONEDATA,20091027,26.90,26.90,26.30,26.30,374670
ONEDATA,20091026,26.90,27.10,26.50,27.00,394278
ONEDATA,20091025,27.40,27.50,26.80,26.90,487238
ONEDATA,20091024,27.30,27.80,26.90,27.50,335160
ONEDATA,20091021,27.00,27.30,26.00,27.10,1294626
ONEDATA,20091020,27.80,27.90,27.00,27.10,337172
ONEDATA,20091019,28.80,28.90,27.60,27.80,944246
ONEDATA,20091018,28.50,30.40,28.00,28.30,1652822
how to divide column (<open>,<high>,<low>,<close>,<val> ) by number for <item> (DATATWO) starting from certain date as example (DATATWO,20091121,34.00,34.20,34.00,34.00,51884) and go Descending
only for DATATWO
thank you
Is this a csv/txt file data?
这篇关于从特定日期开始按数字除以列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!