I have a csv file like that
JavaScript
x
5
1
Meme1, Meme2, Meme3, Meme4, Meme5, Meme6
2
Meme1, Meme2, Meme3, Meme99, Meme5, Meme6
3
Meme5, Meme2, Meme2, Meme4, Meme10, Meme6
4
Meme99, Meme3, Meme4, Meme4, Meme5, Meme6
5
I want like that
JavaScript
1
4
1
00000001, 00000010, 00000011, 00000100, 00000101, 00000110
2
00000001, 00000010, 01100011, 00000100, 00000101, 00000110
3
00000100, 00000010, 00000010, 00000100, 00001010, 00000110
4
means every integer should be converted to binary and word meme should be deleted
JavaScript
1
16
16
1
I am trying but cannot do:(
2
import pandas as pd
3
import csv
4
import numpy as np
5
6
dataset = pd.read_csv('datsetcoma.txt')
7
reader = csv.DictReader(dataset)
8
print (reader)
9
# print back the headers
10
for row in reader:
11
if row.is_integer:
12
13
b=np.binary_repr(10, width=8)
14
print (b)
15
16
Advertisement
Answer
You can also try this:
JavaScript
1
20
20
1
import pandas as pd
2
import numpy as np
3
import io
4
5
# example taken from @ifly6
6
df = pd.read_csv(io.StringIO('''Meme1, Meme2, Meme3, Meme4, Meme5, Meme6
7
Meme1, Meme2, Meme3, Meme99, Meme5, Meme6
8
Meme5, Meme2, Meme2, Meme4, Meme10, Meme6
9
Meme99, Meme3, Meme4, Meme4, Meme5, Meme6'''), header=None)
10
11
df.apply(lambda x: x.apply(lambda y: bin(int(y.replace('Meme', '')))[2:].zfill(8) ) )
12
13
#output
14
15
0 1 2 3 4 5
16
0 00000001 00000010 00000011 00000100 00000101 00000110
17
1 00000001 00000010 00000011 01100011 00000101 00000110
18
2 00000101 00000010 00000010 00000100 00001010 00000110
19
3 01100011 00000011 00000100 00000100 00000101 00000110
20