POST
|
Dear Mathew I have a table, with several columns and rows. What I want to do is to take the values from selected cells and assign them as a variable so I can do some calculations afterwards. In most of my cases I only need to look at one row and one column so I can get the value pretty easy. But I have one case where I need to take the values from several rows on a column. I need to assign each of these (cell) values to a different variable. The values are like the one shown on the previous example. I have them already on a dict, now I need is a way to convert the dict values into variable Thanks again for the interest regards EZ
... View more
03-03-2014
05:43 AM
|
0
|
0
|
1110
|
POST
|
Hey Johs thanks for the input. I kept on searching and start working with the dic idea as well. still my problem is how to convert the values(when there is more than one) from the dic into variables?? so far I am using this code
import arcpy
arcpy.env.workspace = "D:\GIS\LCAv2.gdb"
fc1 = "D:\\GIS\\LCAv2.gdb\\houses"
def rows_as_dicts(cursor):
colnames = cursor.fields
for row in cursor:
yield dict(zip(colnames, row))
# Create field name with the proper delimiters
#
whereclause = """BlockHouse > 0"""
# Use SearchCursor to access state name and the population count
#
with arcpy.da.SearchCursor(fc1, ("materials", "BlockHouse"), whereclause) as sc:
for row in rows_as_dicts(sc):
print row['materials']
print row['BlockHouse']
the output is the following Cement mortar, at plant (Plaster) 1123.2 Reinforcing steel, at plant/RER U 128.34 Lightweight concrete block, expanded clay, at plant/CH U 2106.0 my problem is how to convert the values on "BlockHouse" in to variable like: X= 1123.2 Y = 128.34 Z = 2106.0 thanks again for any pointers regards EZ
... View more
03-03-2014
05:02 AM
|
0
|
0
|
1110
|
POST
|
Hello I am quiet new on programing and I need some help. I want to read the values on a table a then turn them into a variable for future calculations. I have no problem with one result from the cursor.search (code bellow). But in some cases I have multiple results (up to 6) on the cursor.search. So how can I assign each of those 6 results to an independent variable ??? thanks in advance for your help regards EZ 8-D
with arcpy.da.SearchCursor(fc1, ("CountryID", "Total_Impact"), whereclause) as cursor:
for row in cursor:
# Access and print the row values by index position.
# Country name: row[0]
# Env Impact: row[1]
#
print('{0} has an impact in {1}'.format(row[0], row[1]))
x = row[1]
... View more
03-03-2014
03:26 AM
|
0
|
6
|
1455
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|