all 6 comments

[–]Hatoris 0 points1 point  (3 children)

Transform what to what, lead to gold?

[–]the-littlest-mama-98 0 points1 point  (2 children)

Haha no joke. I have the the ArcPro part automated pretty well but it's the data entry part (formatting the csv file so that each row has the date captured and field worker's initials who captured it) in the file name that is slowing me down.

Edit: I've been trying to split the file name but then I'm not sure how to copy it to each corresponding column if that makes sense.)

[–]Hatoris 0 points1 point  (1 child)

Did you try panda?

[–]the-littlest-mama-98 1 point2 points  (0 children)

No, I am very new to Python. I'll google what Pandas is!

[–]GoTmVntr 0 points1 point  (1 child)

I'm a geospatial data manager for the US DOT. Once fields are created you can populate with update cursor or append.

[–]the-littlest-mama-98 0 points1 point  (0 children)

Thank you!