Python Forum
Sum with substr in Python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sum with substr in Python
#1
Hi everyone,

I am a SAS user and it has a very useful function call substr. I cannot find an equivalent for Pandas or Python.

I am trying to sum a variable where another string variables first two letters = '08'

my attempt is below:

data.loc[data.Hs_code[0:1] == '08'].Imports_vfd.sum()
My error:TypeError: invalid type comparison

Any help is appreciated
Thanks
Reply


Messages In This Thread
Sum with substr in Python - by Scott - Jun-22-2019, 10:16 PM
RE: Sum with substr in Python - by ichabod801 - Jun-23-2019, 12:27 AM
RE: Sum with substr in Python - by Scott - Jun-23-2019, 03:52 AM
RE: Sum with substr in Python - by ThomasL - Jun-23-2019, 07:21 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Substr on Pandas Dataframe Scott 1 2,637 Sep-02-2019, 02:49 AM
Last Post: scidam

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020