skip to content

promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_❯continue · ch 00 ❯continue · ch 00 ❯continue · ch 00 ❯continue · ch 00 ❯continue · ch 00 ❯continue · ch 00 ❯continue · ch 00 ❯continue · ch 00 ❯continue · ch 00 ❯continue · ch 00 ❯continue · ch 00

[ follow on x ]

Groupby, joins, and first features (step 3/7) · dataframes with numpy and pandas · promptdojoGroupby, joins, and first aggregates (step 3/7) · dataframes with numpy and pandas · promptdojo

Groupby, joins, and first features — step 3 of 7

python for builders

python for builders

python for builders

python for builders

python for builders

python for builders

python for builders

python for builders

python for builders

python for builders

python for builders

the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas the ml package map — numpy, pandas, sklearn, torchthe table package map — numpy and pandas

array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table array and series shapes - the table before the tablearray and series shapes - the table before the table

dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing dataframe selection and cleaning without guessingdataframe selection and cleaning without guessing

missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug missing values, dtypes, and the silent model bugmissing values, dtypes, and the silent table bug

groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates groupby, joins, and first featuresgroupby, joins, and first aggregates

01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…01groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…groupby, joins, and your first features raw event rows are rarely what…
02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…02you merge a 10,000-row users table with an orders table and the result…
03read the code. what does it print?03read the code. what does it print?03read the code. what does it print?03read the code. what does it print?03read the code. what does it print?03read the code. what does it print?03read the code. what does it print?03read the code. what does it print?03read the code. what does it print?03read the code. what does it print?03read the code. what does it print?
04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…04fill in the dict method that means 'get this key's list, creating an…
05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…05this 'attach order totals to every user' code silently drops sam, who…
06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…06write per_user(rows): group (user, amount) events and return a dict…
07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…07checkpoint. write left_join(users, features, default): return one row…

mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe mission: api rows to a model-ready dataframemission: api rows to an analysis-ready dataframe

ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas3/7

promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_›phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems›ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas

lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregatesstep 3 of 7 in this lesson

Read the code. What does it print?

your prediction

Cmd/Ctrl + Enter runs the editor.open the editor to run it.

ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas3/7

promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_promptdojo_›phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems phase 06 · ml systems›ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas ch 35 · dataframes with numpy and pandas

lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregates lesson 5 of 6 · groupby, joins, and first featuresgroupby, joins, and first aggregatesstep 3 of 7 in this lesson

Read the code. What does it print?

your prediction

Cmd/Ctrl + Enter runs the editor.open the editor to run it.