更改列中的字符串值Pandas Python

Question

下面有一个pandas csv文件。在symbol列中，我想将所有的BTC/USD图替换为BTCUSD。我怎么能做到呢?

代码:

# read_csv function which is used to read the required CSV file
data = pd.read_csv("sample.txt")

csv文件:

unix,date,symbol,open,high,low,close,Volume BTC
1544217600,2018-12-07 21:20:00,BTC/USD,3348.77,3350.41,3345.07,3345.12,3.11919918
1544217540,2018-12-07 21:19:00,BTC/USD,3342.24,3351.14,3342.24,3346.37,21.11950697
1544217480,2018-12-07 21:18:00,BTC/USD,3336.02,3336.02,3336.02,3336.02,0.0
1544217420,2018-12-07 21:17:00,BTC/USD,3332.26,3336.02,3330.69,3336.02,3.28495056

预期输出:

unix,date,symbol,open,high,low,close,Volume BTC
1544217600,2018-12-07 21:20:00,BTCUSD,3348.77,3350.41,3345.07,3345.12,3.11919918
1544217540,2018-12-07 21:19:00,BTCUSD,3342.24,3351.14,3342.24,3346.37,21.11950697
1544217480,2018-12-07 21:18:00,BTCUSD,3336.02,3336.02,3336.02,3336.02,0.0
1544217420,2018-12-07 21:17:00,BTCUSD,3332.26,3336.02,3330.69,3336.02,3.28495056

Answer 1

# importing pandas module 
import pandas as pd

# reading csv file 
data = pd.read_csv("sample.txt")

# overwriting column with replaced value
data["Team"]= data["symbol"].str.replace("BTC/USD", "BTCUSD", case = False)

Answer 2

您可以这样使用str.replace:

df['symbol'] = df['symbol'].str.replace('BTC/USD','BTCUSD')