Hi All, I have one NetCDF file, that contain monthly value for the different year (1910 - 2014). I want to extract few years data (e.g 2000 - 2014), date range reading from a csv file and save it as a raster map as the name format of year-month-date. I am working on below script but I am getting error Below i have attached the csv file which i am using for date range purpose. Any help would be greatly appreciated! Thanks The image showing the format of Year-month-date Error massage Traceback ( most recent call last ) : File " " , line 18 , in module > ValueError : 'Date' is not in list Here what i have so far import os , sys import arcpy # Check out any necessary licenses arcpy . CheckOutExtension ( "spatial" ) arcpy . env . overwriteOutput = True # Script arguments netCDF = "C:\\Users\\Downloads\\SPIE" rainfall = "C:\\Users\\Downloads\\SPIE\\New folder" arcpy . env . workspace = netCDF # Read Date from csv file eveDate = open ( "C:\\Users\\Downloads\\SPIE\\Name1.csv" ) headerLine = eveDate . readline ( ) valueList = headerLine . split ( "," ) dateValueIndex = valueList . index ( "Date" ) eventList = [ ] for line in eveDate . readlines ( ) : segmenLine = line . split ( "," ) variable = "spei" x_dimension = "lon" y_dimension = "lat" band_dimension = "" for year in range ( 2010 ) : nc_name = 'spei.%d.nc' % ( year , ) valueSelectionMethod = "BY_VALUE" outFile = "Pre" # extract dimensionValues from csv file arcpy . MakeNetCDFRasterLayer_md ( "spei.nc" , variable , x_dimension , y_dimension , outFile , band_dimension , segmenLine [ dateValueIndex ] , valueSelectionMethod ) print "layer done" #copy and save as raster tif file arcpy . CopyRaster_management ( outFile , rainfall + segmenLine [ dateValueIndex ] + ".tif" , "" , "" , "" , "NONE" , "NONE" , "" ) print "raster done" Name1.csv.zip Dan.jpg DerrickWestoby_0-1634571185950.png

good, now you know how slicing works

Dan Patterson, Thank you. I just solved the issue, using below command if int ( nowFile [ - 4 : ] ) == 2002 : Thank you all for your kind cooperation.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcPy Error: Date' is not in list, While extracting monthly data from timeseries NetCDF

ShouvikJha

Hi All,

I have one NetCDF file, that contain monthly value for the different year (1910 - 2014). I want to extract few years data (e.g 2000 - 2014), date range reading from a csv file and save it as a raster map as the name format of year-month-date. I am working on below script but I am getting error

Below i have attached the csv file which i am using for date range purpose.

Any help would be greatly appreciated! Thanks

The image showing the format of Year-month-date

Error massage

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"<module4>"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">18</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
ValueError<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Date'</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> list‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Here what i have so far

<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</SPAN> sys
<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="comment token"># Check out any necessary licenses</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CheckOutExtension<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"spatial"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="comment token"># Script arguments</SPAN>
netCDF <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\\Users\\Downloads\\SPIE"</SPAN>
rainfall <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\\Users\\Downloads\\SPIE\\New folder"</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> netCDF

<SPAN class="comment token"># Read Date from csv file</SPAN>
eveDate <SPAN class="operator token">=</SPAN> open <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"C:\\Users\\Downloads\\SPIE\\Name1.csv"</SPAN><SPAN class="punctuation token">)</SPAN>
headerLine <SPAN class="operator token">=</SPAN> eveDate<SPAN class="punctuation token">.</SPAN>readline<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
valueList <SPAN class="operator token">=</SPAN> headerLine<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">)</SPAN>
dateValueIndex <SPAN class="operator token">=</SPAN> valueList<SPAN class="punctuation token">.</SPAN>index<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Date"</SPAN><SPAN class="punctuation token">)</SPAN>
eventList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> line <SPAN class="keyword token">in</SPAN> eveDate<SPAN class="punctuation token">.</SPAN>readlines<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; segmenLine <SPAN class="operator token">=</SPAN> line<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; variable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"spei"</SPAN>
&nbsp;&nbsp;&nbsp; x_dimension <SPAN class="operator token">=</SPAN> <SPAN class="string token">"lon"</SPAN>
&nbsp;&nbsp;&nbsp; y_dimension <SPAN class="operator token">=</SPAN> <SPAN class="string token">"lat"</SPAN>
&nbsp;&nbsp;&nbsp; band_dimension <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>

<SPAN class="keyword token">for</SPAN> year <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2010</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; nc_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">'spei.%d.nc'</SPAN> <SPAN class="operator token">%</SPAN> <SPAN class="punctuation token">(</SPAN>year<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; valueSelectionMethod <SPAN class="operator token">=</SPAN> <SPAN class="string token">"BY_VALUE"</SPAN>
&nbsp;&nbsp;&nbsp; outFile <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Pre"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># extract dimensionValues from csv file</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>MakeNetCDFRasterLayer_md<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"spei.nc"</SPAN><SPAN class="punctuation token">,</SPAN> variable<SPAN class="punctuation token">,</SPAN> x_dimension<SPAN class="punctuation token">,</SPAN> y_dimension<SPAN class="punctuation token">,</SPAN> outFile<SPAN class="punctuation token">,</SPAN> band_dimension<SPAN class="punctuation token">,</SPAN> segmenLine<SPAN class="punctuation token">[</SPAN>dateValueIndex<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> valueSelectionMethod<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"layer done"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#copy and save as raster tif file</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CopyRaster_management<SPAN class="punctuation token">(</SPAN>outFile<SPAN class="punctuation token">,</SPAN> rainfall <SPAN class="operator token">+</SPAN> segmenLine<SPAN class="punctuation token">[</SPAN>dateValueIndex<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">".tif"</SPAN> <SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NONE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NONE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"raster done"</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Name1.csv.zip

Dan.jpg

DerrickWestoby_0-1634571185950.png

Trouver plus de publications taguées avec

Accepted answers

All comments

ShouvikJha

Dan Patterson‌, Thank you. I just solved the issue, using below command

<SPAN class="keyword token">if</SPAN> int<SPAN class="punctuation token">(</SPAN>nowFile<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">2002</SPAN><SPAN class="punctuation token">:</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Thank you all for your kind cooperation.

ShouvikJha

Dan Patterson‌ sorry for late response. I was out of station.

Here i tried to follow your suggestion. after assign the year (2002), its create only one raster not extracting all month data in 2002.

dimension_values <SPAN class="operator token">=</SPAN> nc_FP<SPAN class="punctuation token">.</SPAN>getDimensionValue<SPAN class="punctuation token">(</SPAN>dimension<SPAN class="punctuation token">,</SPAN> i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nowFile <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>dimension_values<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nowFile <SPAN class="operator token">=</SPAN> nowFile<SPAN class="punctuation token">.</SPAN>translate<SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'/'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nowFile <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'2002'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># I needed only the years 2002</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> int<SPAN class="punctuation token">(</SPAN>nowFile<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

you should be using colons when you are parsing, inyour case, you want the last two characters and you will be doing an equality check

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> nowfile <SPAN class="operator token">=</SPAN> <SPAN class="string token">'1989'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> whatisit <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>nowfile<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> whatisit
<SPAN class="number token">8</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> howabout <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>nowfile<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> howabout <SPAN class="operator token">==</SPAN> int<SPAN class="punctuation token">(</SPAN>nowfile<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="token boolean">True</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

ShouvikJha

Dan Patterson‌, @Joshus, I have made some changes in the script, rather than using CSV for extracting particular time period, i am using below script to extract desired time period raster from NetCDF, here line no 14 controlling the time period,

<SPAN class="" style="color: #101094; border: 0px; font-size: 13px;">if</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;"> int</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;">(</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;">nowFile</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;">[-</SPAN><SPAN class="" style="color: #7d2727; border: 0px; font-size: 13px;">2</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;">])</SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;"> </SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;">></SPAN><SPAN class="" style="color: #303336; border: 0px; font-size: 13px;"> </SPAN><SPAN class="" style="color: #7d2727; border: 0px; font-size: 13px;">6</SPAN>

In above line > 6 is extracting the all year data after 1988, when i increase the value by 1 then extracting year also sifting by1 year (e.g. If i put 7 then it would be extract all the year of 1989).

But i want to make a condition for extracting the specific year, e.g1985 to 1990, i don't want pre and post data of that year.

Any assist would be greatly appreciated. Thanks

nc_FP <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>NetCDFFileProperties<SPAN class="punctuation token">(</SPAN>inNetCDF<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> nc_FP
nc_Dim <SPAN class="operator token">=</SPAN> nc_FP<SPAN class="punctuation token">.</SPAN>getDimensions<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> dimension <SPAN class="keyword token">in</SPAN> nc_Dim<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> dimension <SPAN class="operator token">==</SPAN> <SPAN class="string token">"time"</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; top <SPAN class="operator token">=</SPAN> nc_FP<SPAN class="punctuation token">.</SPAN>getDimensionSize<SPAN class="punctuation token">(</SPAN>dimension<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> top<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dimension_values <SPAN class="operator token">=</SPAN> nc_FP<SPAN class="punctuation token">.</SPAN>getDimensionValue<SPAN class="punctuation token">(</SPAN>dimension<SPAN class="punctuation token">,</SPAN> i<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nowFile <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>dimension_values<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nowFile <SPAN class="operator token">=</SPAN> nowFile<SPAN class="punctuation token">.</SPAN>translate<SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'/'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># I needed only the years 1990, post 1990 data i don't want </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> int<SPAN class="punctuation token">(</SPAN>nowFile<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dv1 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"time"</SPAN><SPAN class="punctuation token">,</SPAN> dimension_values<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dimension_values <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>dv1<SPAN class="punctuation token">]</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>MakeNetCDFRasterLayer_md<SPAN class="punctuation token">(</SPAN>inNetCDF<SPAN class="punctuation token">,</SPAN> variable<SPAN class="punctuation token">,</SPAN> x_dimension<SPAN class="punctuation token">,</SPAN> y_dimension<SPAN class="punctuation token">,</SPAN> nowFile<SPAN class="punctuation token">,</SPAN> band_dimension<SPAN class="punctuation token">,</SPAN> dimension_values<SPAN class="punctuation token">,</SPAN> valueSelectionMethod<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"success"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outname <SPAN class="operator token">=</SPAN> outLoc <SPAN class="operator token">+</SPAN> nowFile
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CopyRaster_management<SPAN class="punctuation token">(</SPAN>nowFile<SPAN class="punctuation token">,</SPAN> outname <SPAN class="operator token">+</SPAN> <SPAN class="string token">".tif"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NONE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NONE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>


&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Enter a Valid year"</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

ShouvikJha

Hi All, Please provide your suggestion to solve this issue. i still stuck

ShouvikJha

Actually i am trying to extract one year data from time series netCDF file. My NetCDF file contain monthly data from 1901-2014. So i need to extract the monthly data for different year and make it as raster map.

And i removed the second loop, line no 27 and 28, but problem is same. Now also i am getting the single output as name of output "newfolde". Why such type of output and output's name occurring?. Please guide us to solve this issue.

Why this script not looping all the date value and not make any raster which i have in csv file?

JoshuaBixby

Not sure this will solve your issue, but there are a couple other items that caught my eye. One, the loop you start on Line 20. You are looping through a file to read values, but you are not storing all the values, just the last one read. The way the code is written, segmenLine will only be the last Date value in the CSV file.

Second, I am not sure what you are attempting to do with the loop that starts on Line 27. Range(2010) will return a list containing 2010 values starting at 0 and ending at 2009, is that really what you want?

ShouvikJha

@joshua Bixby, Thank you. I have corrected my csv file, as replaced in line series all the date value, after the correction of my csv file , script is running without any error but i am getting only single output as newfolder name. Now what should i do to loop through all the date range which i have in csv file

I have mentioned date range in csv file, like.

Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">01</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">02</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">03</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">04</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">05</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">06</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">07</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">08</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">09</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">10</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">11</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="number token">2010</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">12</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">16</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

JoshuaBixby

The CSV file you attached has one column, Date. When you do readline, it is including the newline character. So, what you have is ['Date\n'] and not ['Date'], hence the value error.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.