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 - explode

Pandas json normalize why it returns NaN for repeated values

I have a dataframe where 2 columns are lists of dictionaries that I want to expand to separate columns. For example: id text agg_inds ag...
test-img

joasa

python

pandas

explode

json-normalize

Votes: 0

Answers: 2

Latest Answer

You can use ffill to replace the NaN values with the value of the previous row. For this you only have to add one line: s = (df.set_index('id') .apply(lambda x: x.apply(pd.Series).stack()) ...
test-img

JANO

Python: How to expand column with list of values to multiple rows?

Have got a df which looks like this: Item Match a bb,cc b dd,ee want to expland the column 'Match' as below: Item Match a bb a cc b dd b ee tried df.explode...
test-img

user12345

python

pandas

dataframe

explode

expand

Votes: 0

Answers: 1

Latest Answer

I think this will solve your issue: import pandas as pd df = pd.DataFrame({"Item": ["a", "b"], "Match": ["bb,cc", "dd,ee"]}) df["Match&...
test-img

Antoine

suggestion for tune up the code which contains explode and groupby

I wrote the code for below probelem but it has below problems. Please suggest me if some tuning can be done. It takes more time I think. there are 3 brands as of now. It is hardcoded. If more brands ...
test-img

NickyPatel

scala

performance

apache-spark

apache-spark-sql

explode

Votes: 0

Answers: 2

Latest Answer

You can simplify your code using higher-order function filter on arrays. Just map through brand names and for-each one return a filtered array from pref. This way you avoid the exploding / grouping pa...
test-img

blackbishop

PHP: Exploding string => last element is empty, but not recognized as empty

I'm struggling with a behaviour in PHP and finally needed to sign up on stackoverflow as I could not find any answer to my problem for the very first time! :D In my code, I'm getting the following con...
test-img

Patrick

php

explode

Votes: 0

Answers: 1

Latest Answer

The browser is normalising the line separation with carriage return line feeds. So when you split on a line feed, you still have a carriage return in the last part. <?php $data = $_POST['data']; ...
test-img

Progrock

Posts

Questions

Blogs

Jobs