How to sum delimited text in python in excel
I slowly started using python in excel. Somehow I managing the code, however this time I I have received my output data is delimited with ",". How to do it with py option excel.
Based on the below pic, sum of aa,dd,ee is 18, bb,gg is 9 and so on.. I can do it sum individual but not sure how to deal with delimited text. Any help would appreciate. Thank you.
Solution
Enter in E2 with =PY:
df_nv = xl("A1:B10", headers=True)
names = xl("D2:D5").iloc[:,0]
nv = dict(zip(df_nv["Name"],df_nv["Value"]))
def sum_split(a):
return sum(map(lambda a: nv[a], a.split(",")))
list(map(sum_split, names))
Siddharth Rout's answer has better checks - for example xl returns dataFrame only for multi-cell inputs.
- How to use asyncio with existing blocking library?
- Pytorch Convolution Network: problem with floating point type
- Format a column of data in excel into percentage using win32 python
- Using Python in Excel and trying to insert value from Python into cell
- How to sum delimited text in python in excel
- Python in Excel - Importing pvlib library
- Is collections.defaultdict thread-safe?
- Interleave multiple lists of the same length in Python
- Ignore Conda virtual environments in VSCode
- Prettier vscode extension not support Django template tags {% tag %}
- AttributeError: Calling operator "bpy.ops.import_scene.obj" error, could not be found
- How to add aliases to consecutive occurrences in column?
- Understanding NumPy's einsum
- UnicodeEncodeError: 'latin-1' codec can't encode character '\u2013' (writing to PDF)
- Creating a basic auto clicker in python
- How to save shap summary_plot as image file
- Difference between len() and .__len__()?
- How do you round UP a number?
- Why does `strftime("%Y")` not yield a 4-digit year for dates < 1000 AD in Python's datetime module on Linux?
- How to use map() to call methods on a list of objects
- How to create a new channel using nextcord
- What's the best way to store a phone number in Django models?
- tkinter.Listbox has a "shadow selection" beside the proper selection. How to sync both?
- concurrent.futures.ProcessPoolExecutor hangs when the function is a lambda or nested function
- how to get the size of a text with line breaks with Pillow Python
- Why does pd.to_datetime('2025175', format='%Y%W%w') and pd.Timestamp.fromisocalendar(2025, 17, 5) gives different output?
- How to initialize a set and print an empty set {} in python?
- scipy - generate random variables with correlations
- Can't access path parameters from middleware
- Is there a multithreaded map() function?