How to delete quotation marks in dataframe

Question

I have a dataframe like this:

number    file
  1       "[file1,file2]"
  2       [file1]
  3       "[file3,file4]

I want to delete the ". This is what I've tried:

 data = df.replace([\"], '', regex=True)

But, nothing changes in my dataframe. How do I solve this problem?

Thank you.

@MohitMotwani I assumed this is a column of strings, but if not then it probably would not work well like `replace`. — cs95, Jul 01 '19 at 06:11
Either you've mixed lists and strings, or you have a column of strings that look like lists. — cs95, Jul 01 '19 at 06:19
@cs95 I have a column of lists, but when save it into csv file, I got quotation mark in column where the list more than one items — elisa, Jul 01 '19 at 06:23
When you read it back, you read them as strings. print `df['file'].head().tolist()` and take a look. — cs95, Jul 01 '19 at 06:24
I got : `["[file1,file2]",...]` how about quotation mark? is it affect its data type? — elisa, Jul 01 '19 at 06:30

score 5 · Accepted Answer · answered Jul 01 '19 at 06:05

5

import pandas as pd
df = pd.read_csv("test.csv",delimiter=',')
data = df.replace('"', '', regex=True)
print(data)

answered Jul 01 '19 at 06:05

Mobasshir Bhuiya

1 Answers1