擅长:python、mysql、java
<p>我假设“TBC”意味着游戏将在未来某个时间发生(“待确认”)。因此,如果要在分析中使用日期,我建议您使用“TBC”作为日期筛选行:</p>
<pre><code>df_melt_no_tbc = df_melt[df_melt.Date != "TBC"]
</code></pre>
<p>你也可以用其他几种方法来做!见<a href="https://stackoverflow.com/a/45489976/5135448">this post</a>了解其他一些备选方案。下面是一个完整的输出示例:</p>
<pre><code>>>> import pandas as pd
>>>
>>> columns =["MatchID", "GameWeek", "Date", "Team", "Home", "AgainstTeam"]
>>> data = [["1", "1", "01-02-2020", "TeamA", "Here", "TeamB"],
... ["1", "1", "TBC", "TeamB", "Here", "TeamA"]]
>>> df_melt = pd.DataFrame(data, columns=columns)
>>> print(df_melt)
MatchID GameWeek Date Team Home AgainstTeam
0 1 1 01-02-2020 TeamA Here TeamB
1 1 1 TBC TeamB Here TeamA
>>> df_melt_no_tbc = df_melt[df_melt.Date != "TBC"]
>>> print(df_melt_no_tbc)
MatchID GameWeek Date Team Home AgainstTeam
0 1 1 01-02-2020 TeamA Here TeamB
</code></pre>