python - 如果它是python中的逗号，如何删除第一个字符

Question

我在 Dataframe 中有一个数据集，例如：

A  B
a  ,FL,GA,KL
b  CA
c  ,KS

B 列中的一些值以逗号开头。如何删除以逗号开头的单元格的第一个逗号。我的代码在 python 中。

谢谢

标签： pythondataframe

Answer 1

# Open data and put each line into data[]
with open("mydatafile.txt") as datafile:
    data = datafile.read().split("\n")

newdata = []
for line in data:
    if line[0] == ",": # Remove comma or whatever if its there
        line = line[1:]
    newdata.append(line)

# Write new data to file
with open("mynewdatafile.txt","w+") as newdatafile:
    for line in newdata:
        newdatafile.write(line+"\n")

那应该工作