python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - series

How to make new pandas column based on multiple conditionals including 'isnull', 'or' and if colB 'isin' colA -like statements?

First time asking. Is there a way to get a new df column including all three statements (or, isnull-like, isin-like) without iterating over a for loop/ keeping code within the spirit of Pandas? I've t...
test-img

BLT

python

pandas

conditional-statements

series

Votes: 0

Answers: 5

Latest Answer

When using axis=1, the applied function receives a single row as an argument. Indexing into the row gives you string objects, in most cases -- except where a NaN is encountered. Numpy NaNs are actuall...
test-img

Woodrow Barlow

AttributeError:'str' object has no attribute 'unique' (Pandas.unique)

In my script, I use pandas module. When I execute my file.py - everything works well. But I've converted my file.py to file.exe with auto-py-to-exe and got an error: AttributeError:'str' object has no...
test-img

Aleksandr Tyshkevich

pandas

pyinstaller

exe

series

attributeerror

Votes: 0

Answers: 1

Latest Answer

When I created virtual env I should have added openpyxl module. And I made it and everything is fine now
test-img

Aleksandr Tyshkevich

pandas Dataframe divide a column with a specific value and create new column with the result?

A B 0 0.119 5.344960e+08 1 0.008 7.950629e+09 2 ...
test-img

Anjali Kushwaha

python

pandas

dataframe

series

Votes: 0

Answers: 2

Latest Answer

You can do something like this: df['B'] = df['A'].rdiv(my_sum).replace(np.inf, 0).astype('int64') You can also change the view option of pandas: pd.set_option('display.float_format', lambda x: '%.3f'...
test-img

Mohammad

pandas.Series.str.cat() not working on last element of the pandas Series

I am trying to concatenate each string element of a pandas Series object with '.NS'. My sample code is as follows: import pandas as pd asSeries = pd.Series(['HCLTECH', 'ADANIPORTS', 'HDFC', 'TECHM', '...
test-img

Balepur

pandas

string

series

cat

Votes: 0

Answers: 1

Latest Answer

That's the expected behaviour - you're concating strings using a separator, no reason for the separator to be thrown at the end. Just add it manually. asTextWithNS = asSeries.str.cat(sep='.NS ') print...
test-img

Patryk Kowalski

Posts

Questions

Blogs

Jobs