topic Re: split text and use parts as variables? in Python Questions

split text and use parts as variables?

Anonymous User — Fri, 19 Oct 2018 22:47:02 GMT

I want to use the numbered parts of this script in the screenshot below as variables. Any suggestions?

Re: split text and use parts as variables?

JoshuaBixby — Sat, 20 Oct 2018 17:00:22 GMT

Can you post another shot without your boxing/highlighting? I am trying to look closer at the structure of your list, but I think there are some important quotes being covered up.

Re: split text and use parts as variables?

DanPatterson_Retired — Sat, 11 Dec 2021 19:03:40 GMT

I am not sure why you want to make a string of a list. I suspect you want filenames from a folder.

#---- get the list and slice the first two as an example

pth = r"c:\Temp"

words = (os.listdir(pth))
words[:2]

['aust_temperature_demo.py', 'aust_temperature_demo.py.zip']

# ---- now see what happens when you 'str' it

words = str(os.listdir(pth))
words[:2]
"['"  # ---- ??????


words  # it is now a string

"['aust_temperature_demo.py', 'aust_temperature_demo.py.zip' ... snip ...  '__pycache__']"

# ---- get files of a certain type ... one method

py_files = [f for f in os.listdir(pth) if f[-3:] == ".py"]

py_files
['aust_temperature_demo.py', ... snip ... 'script1.py', 'script2.py']
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Then split up your filenames

Re: split text and use parts as variables?

Anonymous User — Mon, 22 Oct 2018 15:12:13 GMT

Re: split text and use parts as variables?

DanPatterson_Retired — Mon, 22 Oct 2018 15:20:18 GMT

which was I was pointing out, you made a string of your list. Did you try removing your str(x) line to get your actual file names? and do you filenames actually contain spaces?

Re: split text and use parts as variables?

Anonymous User — Mon, 22 Oct 2018 15:27:57 GMT

Yes, my filenames contain spaces in them. I tried removing the str(x) line but get the following error...

AttributeError: 'list' object has no attribute 'split'

Re: split text and use parts as variables?

DanPatterson_Retired — Sat, 11 Dec 2021 19:03:43 GMT

you don't split the list... you want to split what is in the list

a = ['a file with spaces.py', 'another one for some reason.py']

b = [i.split(' ') for i in a]  # ---- now split on the spaces
 
b

[['a', 'file', 'with', 'spaces.py'],
 ['another', 'one', 'for', 'some', 'reason.py']]
‍‍‍‍‍‍‍‍

Re: split text and use parts as variables?

JoshuaBixby — Mon, 22 Oct 2018 15:56:10 GMT

Can you paste the text into GeoNet? Whenever I try to copy what I see on the screenshot, the Python interpreter keeps giving invalid syntax errors.

Re: split text and use parts as variables?

Anonymous User — Sat, 11 Dec 2021 19:03:46 GMT

I figured out how to call one part of the file name from the first file. I'm needing to throw this in some sort of loop that will grab the same value for each file no matter how many there are at the time. For this test there are only 2 files I'm trying to grab the variable FullNm from.

import os, sys

path = r"C:\Users\anthonyv\Downloads\Upload"
x = (os.listdir(path))
xx = str(x)
words = (xx)
words2 = words.split(" ")
RdNm,RdTyp,Mp,MpNm,Dt = words2[0],words2[1],words2[2],words2[3],words2[4]
OFullNm = "{} {}".format(RdNm,RdTyp)
FullNm = OFullNm.replace("['","")

print (FullNm)‍‍‍‍‍‍‍‍‍‍‍‍

Re: split text and use parts as variables?

DanPatterson_Retired — Sat, 11 Dec 2021 19:03:48 GMT

a = ['Bermuda Rd first.py', 'Bermuda Rd first.py']

b = [i.split(' ') for i in a]  # ---- now split on the spaces

c = [i[:2] for i in b]

c
[['Bermuda', 'Rd'], ['Bermuda', 'Rd']]‍‍‍‍‍‍‍‍

Re: split text and use parts as variables?

RandyBurton — Sat, 11 Dec 2021 19:03:51 GMT

If the filename format is consistent, you could use a couple of splits:

filename = 'Bermuda Rd MP 0_26 102017_TestTable.xlsx'
f = filename.split(' MP ')
address = f[0]
mile = f[1].split(' ')[0]

print address
# Bermuda Rd

print mile
# 0_26

# and if the underscore in mile represents a decimal point
print '.'.join(mile.split('_'))
# 0.26
# or
mile = '.'.join(f[1].split(' ')[0].split('_'))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And using listdir to get filenames in directory:

import os

path = r"C:\Users\anthonyv\Downloads\Upload"

files = os.listdir(path)
for filename in files:
    f = filename.split(' MP ')
    address = f[0]
    # mile = f[1].split(' ')[0] # keep underscore
    mile = '.'.join(f[1].split(' ')[0].split('_')) # convert underscore to period

    print address, mile‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: split text and use parts as variables?

Anonymous User — Tue, 23 Oct 2018 15:25:14 GMT

This is exactly what I was looking for!

-Thanks for your help

Re: split text and use parts as variables?

Anonymous User — Sat, 11 Dec 2021 19:03:53 GMT

Randy,

The last part of this would be to use address and mile variables for use in creating a excel file. Do you know how I could use the results of the first script in some sort of loop to generate a xlsx document? Below is the script I need to combine it with. The end result would be a column of the address results and a column for the mile results.

import os
os.remove("MetroReportAGOL.xlsx")

print ("Previous Report Deleted")

import os, pandas as pd


# Create a Pandas dataframe from the data.
df = pd.DataFrame({'MP': ["{}".format(mile)],'RdNm': ["{}".format(address)]})

# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.ExcelWriter('MetroReportAGOL.xlsx')

# Convert the dataframe to an XlsxWriter Excel object.
df.to_excel(writer, sheet_name='Sheet1')

# Close the Pandas Excel writer and output the Excel file.
writer.save()

print ("Complete")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: split text and use parts as variables?

Anonymous User — Sat, 11 Dec 2021 19:03:56 GMT

Randy Burton‌

I was able to integrate it into the script above but it's not listing both file names.

import os, sys, pandas as pd

path = r"C:\Users\anthonyv\Downloads\Metro\New folder"

files = os.listdir(path)

for filename in files:
    f = filename.split(' MP ')
    address = f[0]
    mile = '.'.join(f[1].split(' ')[0].split('_')) # convert underscore to period
    df = pd.DataFrame({'MP': ["{}".format(mile)],'RdNm': ["{}".format(address)]})

writer = pd.ExcelWriter('MetroReportAGOL.xlsx')
df.to_excel(writer, sheet_name='Sheet1')
writer.save()

print ("Complete")
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍