I have a text file. It should match with string in column1 and add with colum2,3,4 and prints it in a different file. So, far my code is:

**Code**

```
import pandas as pd

data = pd.read_csv('/Users/ankr/Desktop/samp.txt', sep=",", header=None)
data.columns = ['name','val1', 'val2', 'val3', 'val4', 'val5']
my_df = pd.DataFrame(data)
summary = my_df.groupby('name').sum()
print summary

```

**Example Input:**

```
abc,1,1,1,1,0

def,1,0,0,0,1

abc,1,0,0,0,1

def,0,0,0,0,1

xyz,1,1,1,1,0

```

**Expected output**

```
abc,2,1,1,1,1

def,1,1,1,1,2

xyz,1,1,1,1,0

```

**Samp.txt** file

```
abc,1,1,1,1,0
abc,1,1,1,1,0
Def,1,0,0,0,1
Def,1,0,0,0,1

```

**My output:**

```
  name        val1    val2  val3      val4    val5
0  abc         1       1     1         1       0
1  abc         1       1     1         1       0
2  Def         1       0     0         0       1
3  Def         1       0     0         0       1

```

Any help would be appreciated.