Checking field is empty and then adding new row with zeros? Planned maintenance scheduled April 23, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?ArcPy Insert Cursor not inserting all rows?How to check for empty values in fields of a featureclass?Getting first and second row with ArcPy searchcursor?ArcPy Calculate Null Values to Zero in Multiple FieldsUsing SearchCursor - TypeError: Not a Spatial ReferenceWriting ArcPy UpdateCursor based on row test?Search Cursor Return Field Name If All Rows Contain a ValueUsing ArcPy to ListFields inside SearchCursor?Adding row with default values to new created table with ArcPy?Switching from Nested Search Cursors to Dictionaries

Why is it faster to reheat something than it is to cook it?

Sum letters are not two different

Why is Nikon 1.4g better when Nikon 1.8g is sharper?

What is a fractional matching?

Can anything be seen from the center of the Boötes void? How dark would it be?

How much damage would a cupful of neutron star matter do to the Earth?

Performance gap between vector<bool> and array

How would a mousetrap for use in space work?

Crossing US/Canada Border for less than 24 hours

Why do we need to use the builder design pattern when we can do the same thing with setters?

What do you call the main part of a joke?

What does it mean that physics no longer uses mechanical models to describe phenomena?

Did Deadpool rescue all of the X-Force?

How to tell that you are a giant?

Is there a kind of relay that only consumes power when switching?

What is the difference between globalisation and imperialism?

Is it fair for a professor to grade us on the possession of past papers?

How to write this math term? with cases it isn't working

Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?

A term for a woman complaining about things/begging in a cute/childish way

How to play a character with a disability or mental disorder without being offensive?

Why weren't discrete x86 CPUs ever used in game hardware?

Take 2! Is this homebrew Lady of Pain warlock patron balanced?

Significance of Cersei's obsession with elephants?



Checking field is empty and then adding new row with zeros?



Planned maintenance scheduled April 23, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?ArcPy Insert Cursor not inserting all rows?How to check for empty values in fields of a featureclass?Getting first and second row with ArcPy searchcursor?ArcPy Calculate Null Values to Zero in Multiple FieldsUsing SearchCursor - TypeError: Not a Spatial ReferenceWriting ArcPy UpdateCursor based on row test?Search Cursor Return Field Name If All Rows Contain a ValueUsing ArcPy to ListFields inside SearchCursor?Adding row with default values to new created table with ArcPy?Switching from Nested Search Cursors to Dictionaries



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








2















I created a table with three fields but there are no values in these fields. Here is the screenshot of these fields.



enter image description here



I want to add a new row with zeros for all these three fields. Here is my code.



with arcpy.da.UpdateCursor(selectionname,("OBJECTID","FREQUENCY","SUM_Shape_Area")) as cursor:
for row in cursor:
if row[0] == None:
row[0] = 0
cursor.updateRow(row)
else:
print selectionname + " is not empty"


Selectionname is my table, a parameter defined prior to this part of my code. First, I need to check if these three fields are empty, then adding a new row with zeros if they are empty. After several tries, I still could not add a new row to the table.










share|improve this question



















  • 4





    To add a new row you need to be using an InsertCursor.

    – PolyGeo
    Apr 11 at 2:46


















2















I created a table with three fields but there are no values in these fields. Here is the screenshot of these fields.



enter image description here



I want to add a new row with zeros for all these three fields. Here is my code.



with arcpy.da.UpdateCursor(selectionname,("OBJECTID","FREQUENCY","SUM_Shape_Area")) as cursor:
for row in cursor:
if row[0] == None:
row[0] = 0
cursor.updateRow(row)
else:
print selectionname + " is not empty"


Selectionname is my table, a parameter defined prior to this part of my code. First, I need to check if these three fields are empty, then adding a new row with zeros if they are empty. After several tries, I still could not add a new row to the table.










share|improve this question



















  • 4





    To add a new row you need to be using an InsertCursor.

    – PolyGeo
    Apr 11 at 2:46














2












2








2








I created a table with three fields but there are no values in these fields. Here is the screenshot of these fields.



enter image description here



I want to add a new row with zeros for all these three fields. Here is my code.



with arcpy.da.UpdateCursor(selectionname,("OBJECTID","FREQUENCY","SUM_Shape_Area")) as cursor:
for row in cursor:
if row[0] == None:
row[0] = 0
cursor.updateRow(row)
else:
print selectionname + " is not empty"


Selectionname is my table, a parameter defined prior to this part of my code. First, I need to check if these three fields are empty, then adding a new row with zeros if they are empty. After several tries, I still could not add a new row to the table.










share|improve this question
















I created a table with three fields but there are no values in these fields. Here is the screenshot of these fields.



enter image description here



I want to add a new row with zeros for all these three fields. Here is my code.



with arcpy.da.UpdateCursor(selectionname,("OBJECTID","FREQUENCY","SUM_Shape_Area")) as cursor:
for row in cursor:
if row[0] == None:
row[0] = 0
cursor.updateRow(row)
else:
print selectionname + " is not empty"


Selectionname is my table, a parameter defined prior to this part of my code. First, I need to check if these three fields are empty, then adding a new row with zeros if they are empty. After several tries, I still could not add a new row to the table.







arcpy arcgis-pro cursor






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Apr 11 at 3:39









Vince

14.8k32850




14.8k32850










asked Apr 11 at 2:41









ZhenyuZhenyu

234




234







  • 4





    To add a new row you need to be using an InsertCursor.

    – PolyGeo
    Apr 11 at 2:46













  • 4





    To add a new row you need to be using an InsertCursor.

    – PolyGeo
    Apr 11 at 2:46








4




4





To add a new row you need to be using an InsertCursor.

– PolyGeo
Apr 11 at 2:46






To add a new row you need to be using an InsertCursor.

– PolyGeo
Apr 11 at 2:46











1 Answer
1






active

oldest

votes


















5














Use GetCount to check if table is empty and da.InsertCursor to insert a row. I dont think you should try to set objectid, let it be set automatically. If you want your own ID then add another field for it.



import arcpy
table = 'C:data.gdbtable123' #Change
fields = ['freq','sum'] #Change

if int(arcpy.GetCount_management(table).getOutput(0)) == 0:
icur = arcpy.da.InsertCursor(table,fields)
icur.insertRow([0,0])
del icur





share|improve this answer




















  • 1





    this is what I want and really appreciate your help! @BERA

    – Zhenyu
    Apr 11 at 19:43












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
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318440%2fchecking-field-is-empty-and-then-adding-new-row-with-zeros%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









5














Use GetCount to check if table is empty and da.InsertCursor to insert a row. I dont think you should try to set objectid, let it be set automatically. If you want your own ID then add another field for it.



import arcpy
table = 'C:data.gdbtable123' #Change
fields = ['freq','sum'] #Change

if int(arcpy.GetCount_management(table).getOutput(0)) == 0:
icur = arcpy.da.InsertCursor(table,fields)
icur.insertRow([0,0])
del icur





share|improve this answer




















  • 1





    this is what I want and really appreciate your help! @BERA

    – Zhenyu
    Apr 11 at 19:43
















5














Use GetCount to check if table is empty and da.InsertCursor to insert a row. I dont think you should try to set objectid, let it be set automatically. If you want your own ID then add another field for it.



import arcpy
table = 'C:data.gdbtable123' #Change
fields = ['freq','sum'] #Change

if int(arcpy.GetCount_management(table).getOutput(0)) == 0:
icur = arcpy.da.InsertCursor(table,fields)
icur.insertRow([0,0])
del icur





share|improve this answer




















  • 1





    this is what I want and really appreciate your help! @BERA

    – Zhenyu
    Apr 11 at 19:43














5












5








5







Use GetCount to check if table is empty and da.InsertCursor to insert a row. I dont think you should try to set objectid, let it be set automatically. If you want your own ID then add another field for it.



import arcpy
table = 'C:data.gdbtable123' #Change
fields = ['freq','sum'] #Change

if int(arcpy.GetCount_management(table).getOutput(0)) == 0:
icur = arcpy.da.InsertCursor(table,fields)
icur.insertRow([0,0])
del icur





share|improve this answer















Use GetCount to check if table is empty and da.InsertCursor to insert a row. I dont think you should try to set objectid, let it be set automatically. If you want your own ID then add another field for it.



import arcpy
table = 'C:data.gdbtable123' #Change
fields = ['freq','sum'] #Change

if int(arcpy.GetCount_management(table).getOutput(0)) == 0:
icur = arcpy.da.InsertCursor(table,fields)
icur.insertRow([0,0])
del icur






share|improve this answer














share|improve this answer



share|improve this answer








edited Apr 12 at 5:23

























answered Apr 11 at 5:42









BERABERA

17.2k62044




17.2k62044







  • 1





    this is what I want and really appreciate your help! @BERA

    – Zhenyu
    Apr 11 at 19:43













  • 1





    this is what I want and really appreciate your help! @BERA

    – Zhenyu
    Apr 11 at 19:43








1




1





this is what I want and really appreciate your help! @BERA

– Zhenyu
Apr 11 at 19:43






this is what I want and really appreciate your help! @BERA

– Zhenyu
Apr 11 at 19:43


















draft saved

draft discarded
















































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.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318440%2fchecking-field-is-empty-and-then-adding-new-row-with-zeros%23new-answer', 'question_page');

);

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







Popular posts from this blog

រឿង រ៉ូមេអូ និង ហ្ស៊ុយលីយេ សង្ខេបរឿង តួអង្គ បញ្ជីណែនាំ

Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given

Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221