So, I've looked around quite a bit and I haven't been able to find an answer to this problem. I apologize if it is indeed out there.

So, I've looked around quite a bit and I haven't been able to find an answer to this problem. I apologize if it is indeed out there.

I have a DF that looks like this:

a = pd.DataFrame({'Name': ['apple', 'banana', 'orange', 'apple', 'banana','orange'], 'Units': [2,4,6,5,4,3]})

I also have a list of lists like this:

b = [['apple', 'banana'],['orange']]

The goal is to group apple and banana in to 1 column and orange in to another with their respective units summed. The variable in the column will show up as the first item in the sublist. (no sublist will have duplicates).

Here's what I want the output df to look like:

output = pd.DataFrame({'Name': ['apple', 'orange'], 'Units': [15, 9]})

Here's where I am right now:

for fruit in a['Name']: for sublist in b: if fruit in sublist: pd.concat([XYZ, pd.DataFrame({'Name': sublist[0], 'Units': a[a.Name == fruit]['Units'].sum(), index=[0})], axis=1)

XYZ is an empty data frame with columns= Name and Units that I am trying to populate with the results. I don't really understand how to create a data frame when the **fruit is in sublist** along with the sum of it's Units.

Any thoughts?

In this post, we will learn about pandasâ€™ data structures/objects. Pandas provide two type of data structures:- ### Pandas Series Pandas Series is a one dimensional indexed data, which can hold datatypes like integer, string, boolean, float...

In the programming world, Data types play an important role. Each Variable is stored in different data types and responsible for various functions. Python had two different objects, and They are mutable and immutable objects.

Python Pandas Tutorial - Data Analysis with Python Pandas will help you get started with Python Pandas Library for various applications including Data analysis. You'll learn: Introduction to Pandas; DataFrames and Series; How To View Data? Selecting Data; Handling Missing Data; Pandas Operations; Merge, Group, Reshape Data; Time Series And Categoricals; Plotting Using Pandas

PYTHON Pandas Basic Functions. So far, we have learned the three pandas data structure and how to create them. Due to its importance in real-time data processing, we will focus on dataframe objects right now and mention a few other data structures.

Python Pandas Tutorial will help you get started with Python Pandas Library for various applications including Data analysis. Introduction to Pandas. DataFrames and Series. How To View Data? Selecting Data. Handling Missing Data. Pandas Operations. Merge, Group, Reshape Data. Time Series And Categoricals. Plotting Using Pandas