如何从数据格式中创建日期,年份月份day1 day2 day3 day4…day31

我的数据文件(每日降雨量数据)的格式为

df = Year  Month   Day01  Day02  Day03 ..............Day31 
      1970   1       0        0    20                  3.5
      1970   2       0        0    20                  3.5
      1970   3       0        0    20                  3.5
      ...    .       .        .    ..                  ...
      ...    .       .        .    ..                  ...

我想将上述数据读取为日期格式

df = date (year-month-day)

Please help
you can find the data here https://docs.google.com/spreadsheets/d/1sPRiRDYmWyTuuhks3CDWXj0eNcddsJopUNfjEAlSI-w/edit?usp=sharing

评论