create features on one dataset

[alteryx]

create features on one dataset

[turkialjrees]

I belefie the issue here is to understand the fundamental of Automatie ML methods, whcih is A transformation acts on a single table (thinking in terms of Python, a table is just a Pandas DataFrame ) by creating new features out of one or more of the existing columns. Like many topics in machine learning, automated feature engineering is a complicated concept built on simple ideas.
Using concepts of entitysets, entities, and relationships, featuretools can perform deep feature synthesis to create new features.
Deep feature synthesis in turn stacks feature primitives — aggregations, which act across a one-to-many relationship between tables, and transformations, functions applied to one or more columns in a single table — to build new features from multiple tables.

read more with basic example here
https://towardsdatascience.com/automated-feature-engineering-in-python-99baf11cc219

[bukosabino]

Hi @shellwang ,

Can you provide us more details about your goals?

As Max says, you need more related tables to extract this kind of features.

[kmax12]

@billy-odera can you provide an example of a feature you would expect to get created using just that one table?

[billy-odera]

@kmax12 This is the dataframe

customerid  age	   outflows_amout  inflows_amount
1	            28.00	                 0                  355.00	
2	            72.00	                 1	             240.00	
3	            22.00	                 6	              nan

I would expect to get count.outflow_amount, mean,skew etc

[kmax12]

@billy-odera not sure i follow your example. if you want to calculate the mean outflows_amount per customer, you would want to create a second entity for your customers that has a relationship to a the entity with multiple rows per customer with different outflow_amounts. let me know if that's helpful or please provide a complete example of what you want to generate so I can better help.

[shellwang]

Yes. I encounter the same problem.