问题

这是您要翻译的表格：

player	team	opp	wl_g	game_id	match_id
Laz	ZETA	DRX	lose	119512	184456
TENNN	ZETA	DRX	lose	119512	184456
MaKo	DRX	ZETA	win	119512	184456
Foxy9	DRX	ZETA	win	119512	184456
Laz	ZETA	DRX	win	119513	184456
TENNN	ZETA	DRX	win	119513	184456
MaKo	DRX	ZETA	lose	119513	184456
Foxy9	DRX	ZETA	lose	119513	184456
Laz	ZETA	DRX	lose	119514	184456
TENNN	ZETA	DRX	lose	119514	184456
MaKo	DRX	ZETA	win	119514	184456
Foxy9	DRX	ZETA	win	119514	184456

您需要在基于"wl_g"列的值相同的每个"match_id"上创建一个新列"wl_s"，当"wl_g"列中的值为"win"时，"wl_s"列中的值应该相同。以下是您要的表格：

player	team	opp	wl_g	game_id	match_id	wl_s
Laz	ZETA	DRX	lose	119512	184456	lose
TENNN	ZETA	DRX	lose	119512	184456	lose
MaKo	DRX	ZETA	win	119512	184456	win
Foxy9	DRX	ZETA	win	119512	184456	win
Laz	ZETA	DRX	win	119513	184456	lose
TENNN	ZETA	DRX	win	119513	184456	lose
MaKo	DRX	ZETA	lose	119513	184456	win
Foxy9	DRX	ZETA	lose	119513	184456	win
Laz	ZETA	DRX	win	119514	184456	lose
TENNN	ZETA	DRX	win	119514	184456	lose
MaKo	DRX	ZETA	lose	119514	184456	win
Foxy9	DRX	ZETA	lose	119514	184456	win

英文:

here's my table

player	team	opp	wl_g	game_id	match_id
Laz	ZETA	DRX	lose	119512	184456
TENNN	ZETA	DRX	lose	119512	184456
MaKo	DRX	ZETA	win	119512	184456
Foxy9	DRX	ZETA	win	119512	184456
Laz	ZETA	DRX	win	119513	184456
TENNN	ZETA	DRX	win	119513	184456
MaKo	DRX	ZETA	lose	119513	184456
Foxy9	DRX	ZETA	lose	119513	184456
Laz	ZETA	DRX	lose	119514	184456
TENNN	ZETA	DRX	lose	119514	184456
MaKo	DRX	ZETA	win	119514	184456
Foxy9	DRX	ZETA	win	119514	184456

and i need to make a column based on wl_g column with same each value on match_id, im expecting to get value for new colum wl_s(a.k.a win lose for each match_id) when win on wl_g column = 2, is equal value win on wl_s column . Here's the table that i want

player	team	opp	wl_g	game_id	match_id	wl_s
Laz	ZETA	DRX	lose	119512	184456	lose
TENNN	ZETA	DRX	lose	119512	184456	lose
MaKo	DRX	ZETA	win	119512	184456	win
Foxy9	DRX	ZETA	win	119512	184456	win
Laz	ZETA	DRX	win	119513	184456	lose
TENNN	ZETA	DRX	win	119513	184456	lose
MaKo	DRX	ZETA	lose	119513	184456	win
Foxy9	DRX	ZETA	lose	119513	184456	win
Laz	ZETA	DRX	win	119514	184456	lose
TENNN	ZETA	DRX	win	119514	184456	lose
MaKo	DRX	ZETA	lose	119514	184456	win
Foxy9	DRX	ZETA	lose	119514	184456	win

答案1

得分: 1

将"wl_g"和"match_id"列作为基础，添加"wl_s"列：

data = {
    "player": ["Laz", "TENNN", "MaKo", "Foxy9", "Laz", "TENNN", "MaKo", "Foxy9", "Laz", "TENNN", "MaKo", "Foxy9"],
    "team": ["ZETA", "ZETA", "DRX", "DRX", "ZETA", "ZETA", "DRX", "DRX", "ZETA", "ZETA", "DRX", "DRX"],
    "opp": ["DRX", "DRX", "ZETA", "ZETA", "DRX", "DRX", "ZETA", "ZETA", "DRX", "DRX", "ZETA", "ZETA"],
    "wl_g": ["lose", "lose", "win", "win", "win", "win", "lose", "lose", "lose", "lose", "win", "win"],
    "game_id": [119512, 119512, 119512, 119512, 119513, 119513, 119513, 119513, 119514, 119514, 119514, 119514],
    "match_id": [184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456]
}

df = pd.DataFrame(data)

df["wl_s"] = df.groupby("match_id")["wl_g"].transform(lambda x: "win" if (x == "win").any() else "lose")

# 打印结果DataFrame
print(df)

英文:

Add the "wl_s" column based on "wl_g" and "match_id"

data = {
    &quot;player&quot;: [&quot;Laz&quot;, &quot;TENNN&quot;, &quot;MaKo&quot;, &quot;Foxy9&quot;, &quot;Laz&quot;, &quot;TENNN&quot;, &quot;MaKo&quot;, &quot;Foxy9&quot;, &quot;Laz&quot;, &quot;TENNN&quot;, &quot;MaKo&quot;, &quot;Foxy9&quot;],
    &quot;team&quot;: [&quot;ZETA&quot;, &quot;ZETA&quot;, &quot;DRX&quot;, &quot;DRX&quot;, &quot;ZETA&quot;, &quot;ZETA&quot;, &quot;DRX&quot;, &quot;DRX&quot;, &quot;ZETA&quot;, &quot;ZETA&quot;, &quot;DRX&quot;, &quot;DRX&quot;],
    &quot;opp&quot;: [&quot;DRX&quot;, &quot;DRX&quot;, &quot;ZETA&quot;, &quot;ZETA&quot;, &quot;DRX&quot;, &quot;DRX&quot;, &quot;ZETA&quot;, &quot;ZETA&quot;, &quot;DRX&quot;, &quot;DRX&quot;, &quot;ZETA&quot;, &quot;ZETA&quot;],
    &quot;wl_g&quot;: [&quot;lose&quot;, &quot;lose&quot;, &quot;win&quot;, &quot;win&quot;, &quot;win&quot;, &quot;win&quot;, &quot;lose&quot;, &quot;lose&quot;, &quot;lose&quot;, &quot;lose&quot;, &quot;win&quot;, &quot;win&quot;],
    &quot;game_id&quot;: [119512, 119512, 119512, 119512, 119513, 119513, 119513, 119513, 119514, 119514, 119514, 119514],
    &quot;match_id&quot;: [184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456, 184456]
}

df = pd.DataFrame(data)


df[&quot;wl_s&quot;] = df.groupby(&quot;match_id&quot;)[&quot;wl_g&quot;].transform(lambda x: &quot;win&quot; if (x == &quot;win&quot;).any() else &quot;lose&quot;)

# Print the resulting DataFrame
print(df)

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

基于 Pandas 中的其他列的条件。

问题

答案1

如何使用Python中的列表推导将多个列表展平

使用cv.rotate和cv.warpAffine时旋转图像的差异

pandas – 从两个CSV文件合并数据后，每列只显示一个单元格

合并小的Parquet文件成一个大的Parquet文件。

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论