Splitting string ID code into various partsSplitting string in Python parser of ArcGIS Field...
How to deal with a cynical class?
Co-worker team leader wants to inject his friend's awful software into our development. What should I say to our common boss?
Did CPM support custom hardware using device drivers?
How to make healing in an exploration game interesting
Why do passenger jet manufacturers design their planes with stall prevention systems?
What does it mean to make a bootable LiveUSB?
How can I change step-down my variable input voltage? [Microcontroller]
Is it normal that my co-workers at a fitness company criticize my food choices?
Meaning of "SEVERA INDEOVI VAS" from 3rd Century slab
Why must traveling waves have the same amplitude to form a standing wave?
How to generate globally unique ids for different tables of the same database?
Dot in front of file
Why are there 40 737 Max planes in flight when they have been grounded as not airworthy?
Rejected in 4th interview round citing insufficient years of experience
At what level can a dragon innately cast its spells?
How to explain that I do not want to visit a country due to personal safety concern?
What has been your most complicated TikZ drawing?
Provisioning profile doesn't include the application-identifier and keychain-access-groups entitlements
The use of "touch" and "touch on" in context
It's a yearly task, alright
Could the Saturn V actually have launched astronauts around Venus?
Does this property of comaximal ideals always holds?
How to deal with taxi scam when on vacation?
Does the statement `int val = (++i > ++j) ? ++i : ++j;` invoke undefined behavior?
Splitting string ID code into various parts
Splitting string in Python parser of ArcGIS Field Calculator?Select polygons contained inside a polygon and assign IDHow to place points along a line in a specific offset using python / arcpy?Help with formatting ArcGIS text elements with PythonSplitting string column into 2 columns in Python?Find the first occurrence of any letter in an alphanumeric stringRemove first seven characters from field string using Field CalculatorHow can I convert Bing's “quadtree” tile addresses to ZXY tile addresses in Python?Address Prefix Strip Using PythonOverlay two linestring objects in geopandas, accounting for the attributes
I have a series of identification codes that I need to split out. The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)]
.
An example of some codes includes S22-201
, TT100-12
, and V6-1B
. Often there is no subdistrict, and all points fall within the same larger district (so no As or Cs or whatever at the end of the string.
I can do parts of it, like splitting at the hyphen.
!Original_ID!.split('-')[0]
and then extracting the district
!Split_ID![1:3]
But it seems like two steps for this are unnecessary, and only works when I know the specific number of characters in the string, which isn't realistic for a large data set.
I'd like to be able to grab each piece at once:
- letters on the left of the hyphen
- numbers on the left of the hyphen
- numbers on the right of the hyphen
- letters (if any) on the right of the hyphen.
I'd need the numeric fields to be integers (or I guess possibly floats in some rare cases maybe).
python arcmap field-calculator
New contributor
add a comment |
I have a series of identification codes that I need to split out. The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)]
.
An example of some codes includes S22-201
, TT100-12
, and V6-1B
. Often there is no subdistrict, and all points fall within the same larger district (so no As or Cs or whatever at the end of the string.
I can do parts of it, like splitting at the hyphen.
!Original_ID!.split('-')[0]
and then extracting the district
!Split_ID![1:3]
But it seems like two steps for this are unnecessary, and only works when I know the specific number of characters in the string, which isn't realistic for a large data set.
I'd like to be able to grab each piece at once:
- letters on the left of the hyphen
- numbers on the left of the hyphen
- numbers on the right of the hyphen
- letters (if any) on the right of the hyphen.
I'd need the numeric fields to be integers (or I guess possibly floats in some rare cases maybe).
python arcmap field-calculator
New contributor
add a comment |
I have a series of identification codes that I need to split out. The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)]
.
An example of some codes includes S22-201
, TT100-12
, and V6-1B
. Often there is no subdistrict, and all points fall within the same larger district (so no As or Cs or whatever at the end of the string.
I can do parts of it, like splitting at the hyphen.
!Original_ID!.split('-')[0]
and then extracting the district
!Split_ID![1:3]
But it seems like two steps for this are unnecessary, and only works when I know the specific number of characters in the string, which isn't realistic for a large data set.
I'd like to be able to grab each piece at once:
- letters on the left of the hyphen
- numbers on the left of the hyphen
- numbers on the right of the hyphen
- letters (if any) on the right of the hyphen.
I'd need the numeric fields to be integers (or I guess possibly floats in some rare cases maybe).
python arcmap field-calculator
New contributor
I have a series of identification codes that I need to split out. The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)]
.
An example of some codes includes S22-201
, TT100-12
, and V6-1B
. Often there is no subdistrict, and all points fall within the same larger district (so no As or Cs or whatever at the end of the string.
I can do parts of it, like splitting at the hyphen.
!Original_ID!.split('-')[0]
and then extracting the district
!Split_ID![1:3]
But it seems like two steps for this are unnecessary, and only works when I know the specific number of characters in the string, which isn't realistic for a large data set.
I'd like to be able to grab each piece at once:
- letters on the left of the hyphen
- numbers on the left of the hyphen
- numbers on the right of the hyphen
- letters (if any) on the right of the hyphen.
I'd need the numeric fields to be integers (or I guess possibly floats in some rare cases maybe).
python arcmap field-calculator
python arcmap field-calculator
New contributor
New contributor
edited 18 mins ago
Taras
2,2342727
2,2342727
New contributor
asked 5 hours ago
vce500vce500
62
62
New contributor
New contributor
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:
with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
for sRow in uCur:
OrigID = sRow[0].split('-')[0] # first element in the Original_ID
charRng = range(len(OrigID)) # a range to iterate over
Chars = ''
Numbers = ''
for Idx in charRng:
if OrigID[Idx].isnumeric():
Numbers += OrigID[Idx]
else:
chars += OrigID[Idx]
sRow[1] = float(Numbers)
sRow[2] = Chars
uCur.updateRow(sRow)
This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.
add a comment |
Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:
Code Block
import re
def parse(s):
"""The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
An example of a some codes include S22-201, TT100-12, and V6-1B.
Often there is no subdistrict, and all points fall within the same larger district
(so no As or Cs or whatever at the end of the string)."""
letters = re.findall(r'[a-z A-Z]+', s)
numbers = re.findall(r'[0-9]+', s)
region = letters[0]
district, place = [int(n) for n in numbers]
try:
subdistrict = letters[1]
except IndexError:
subdistrict = None
return region, district, place, subdistrict
Then for the region field, use:
parse(!Original_ID!)[0]
For district:
parse(!Original_ID!)[1]
For place:
parse(!Original_ID!)[2]
For subdistrict:
parse(!Original_ID!)[3]
However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:
import re
def parse(s):
etc... from code block above
with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
for row in rows:
region, district, place, subdistrict = parse(row[0])
row = [row[0], region, district, place, subdistrict]
rows.updateRow(row)
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
vce500 is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f315591%2fsplitting-string-id-code-into-various-parts%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:
with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
for sRow in uCur:
OrigID = sRow[0].split('-')[0] # first element in the Original_ID
charRng = range(len(OrigID)) # a range to iterate over
Chars = ''
Numbers = ''
for Idx in charRng:
if OrigID[Idx].isnumeric():
Numbers += OrigID[Idx]
else:
chars += OrigID[Idx]
sRow[1] = float(Numbers)
sRow[2] = Chars
uCur.updateRow(sRow)
This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.
add a comment |
You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:
with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
for sRow in uCur:
OrigID = sRow[0].split('-')[0] # first element in the Original_ID
charRng = range(len(OrigID)) # a range to iterate over
Chars = ''
Numbers = ''
for Idx in charRng:
if OrigID[Idx].isnumeric():
Numbers += OrigID[Idx]
else:
chars += OrigID[Idx]
sRow[1] = float(Numbers)
sRow[2] = Chars
uCur.updateRow(sRow)
This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.
add a comment |
You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:
with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
for sRow in uCur:
OrigID = sRow[0].split('-')[0] # first element in the Original_ID
charRng = range(len(OrigID)) # a range to iterate over
Chars = ''
Numbers = ''
for Idx in charRng:
if OrigID[Idx].isnumeric():
Numbers += OrigID[Idx]
else:
chars += OrigID[Idx]
sRow[1] = float(Numbers)
sRow[2] = Chars
uCur.updateRow(sRow)
This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.
You're not going to be able to calculate two fields in one go.. though you can split it up into two calcs. I would do this with an update cursor:
with arcpy.da.UpdateCursor(YourFeatureClass,['Original_ID','District','Split_ID']) as uCur:
for sRow in uCur:
OrigID = sRow[0].split('-')[0] # first element in the Original_ID
charRng = range(len(OrigID)) # a range to iterate over
Chars = ''
Numbers = ''
for Idx in charRng:
if OrigID[Idx].isnumeric():
Numbers += OrigID[Idx]
else:
chars += OrigID[Idx]
sRow[1] = float(Numbers)
sRow[2] = Chars
uCur.updateRow(sRow)
This shows how to break up a string into numbers and not numbers and put the values into a row, it should give you some ideas where to start from.
answered 5 hours ago
Michael StimsonMichael Stimson
21.6k22360
21.6k22360
add a comment |
add a comment |
Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:
Code Block
import re
def parse(s):
"""The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
An example of a some codes include S22-201, TT100-12, and V6-1B.
Often there is no subdistrict, and all points fall within the same larger district
(so no As or Cs or whatever at the end of the string)."""
letters = re.findall(r'[a-z A-Z]+', s)
numbers = re.findall(r'[0-9]+', s)
region = letters[0]
district, place = [int(n) for n in numbers]
try:
subdistrict = letters[1]
except IndexError:
subdistrict = None
return region, district, place, subdistrict
Then for the region field, use:
parse(!Original_ID!)[0]
For district:
parse(!Original_ID!)[1]
For place:
parse(!Original_ID!)[2]
For subdistrict:
parse(!Original_ID!)[3]
However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:
import re
def parse(s):
etc... from code block above
with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
for row in rows:
region, district, place, subdistrict = parse(row[0])
row = [row[0], region, district, place, subdistrict]
rows.updateRow(row)
add a comment |
Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:
Code Block
import re
def parse(s):
"""The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
An example of a some codes include S22-201, TT100-12, and V6-1B.
Often there is no subdistrict, and all points fall within the same larger district
(so no As or Cs or whatever at the end of the string)."""
letters = re.findall(r'[a-z A-Z]+', s)
numbers = re.findall(r'[0-9]+', s)
region = letters[0]
district, place = [int(n) for n in numbers]
try:
subdistrict = letters[1]
except IndexError:
subdistrict = None
return region, district, place, subdistrict
Then for the region field, use:
parse(!Original_ID!)[0]
For district:
parse(!Original_ID!)[1]
For place:
parse(!Original_ID!)[2]
For subdistrict:
parse(!Original_ID!)[3]
However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:
import re
def parse(s):
etc... from code block above
with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
for row in rows:
region, district, place, subdistrict = parse(row[0])
row = [row[0], region, district, place, subdistrict]
rows.updateRow(row)
add a comment |
Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:
Code Block
import re
def parse(s):
"""The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
An example of a some codes include S22-201, TT100-12, and V6-1B.
Often there is no subdistrict, and all points fall within the same larger district
(so no As or Cs or whatever at the end of the string)."""
letters = re.findall(r'[a-z A-Z]+', s)
numbers = re.findall(r'[0-9]+', s)
region = letters[0]
district, place = [int(n) for n in numbers]
try:
subdistrict = letters[1]
except IndexError:
subdistrict = None
return region, district, place, subdistrict
Then for the region field, use:
parse(!Original_ID!)[0]
For district:
parse(!Original_ID!)[1]
For place:
parse(!Original_ID!)[2]
For subdistrict:
parse(!Original_ID!)[3]
However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:
import re
def parse(s):
etc... from code block above
with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
for row in rows:
region, district, place, subdistrict = parse(row[0])
row = [row[0], region, district, place, subdistrict]
rows.updateRow(row)
Assuming you have four fields, region, district, place and subdistrict already added and you want to use the field calculator to populate them. You would have to run the calculator four times using an expression like:
Code Block
import re
def parse(s):
"""The format of these codes is [region(letter)][district(number)] - [place(number)][subdistrict(letter)].
An example of a some codes include S22-201, TT100-12, and V6-1B.
Often there is no subdistrict, and all points fall within the same larger district
(so no As or Cs or whatever at the end of the string)."""
letters = re.findall(r'[a-z A-Z]+', s)
numbers = re.findall(r'[0-9]+', s)
region = letters[0]
district, place = [int(n) for n in numbers]
try:
subdistrict = letters[1]
except IndexError:
subdistrict = None
return region, district, place, subdistrict
Then for the region field, use:
parse(!Original_ID!)[0]
For district:
parse(!Original_ID!)[1]
For place:
parse(!Original_ID!)[2]
For subdistrict:
parse(!Original_ID!)[3]
However, I would use the update cursor approach suggested by Michael Stimson so you could update all four fields in one hit. Use the following in the python window of ArcMap/ArcGIS Pro:
import re
def parse(s):
etc... from code block above
with arcpy.da.UpdateCursor(YourFeatureClass, ['Original_ID','Region', 'District', 'Place', 'Subdistrict']) as rows:
for row in rows:
region, district, place, subdistrict = parse(row[0])
row = [row[0], region, district, place, subdistrict]
rows.updateRow(row)
edited 2 hours ago
answered 2 hours ago
user2856user2856
30.3k258105
30.3k258105
add a comment |
add a comment |
vce500 is a new contributor. Be nice, and check out our Code of Conduct.
vce500 is a new contributor. Be nice, and check out our Code of Conduct.
vce500 is a new contributor. Be nice, and check out our Code of Conduct.
vce500 is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f315591%2fsplitting-string-id-code-into-various-parts%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown