title: "Sum of All on NA" author: "Rj" date: 2019-04-22 description: "-" type: technical_note draft: false
import numpy as np
import pandas as pd
df = pd.DataFrame(np.random.rand(10, 5))
df
Category: data-wrangling
Read Moretitle: "Unicode Issue and Fix" author: "Rj" date: 2019-04-22 description: "-" type: technical_note draft: false
import numpy as np
import pandas as pd
df = pd.read_csv('score.csv')
---------------------------------------------------------------------------
UnicodeDecodeError Traceback (most recent call last)
<ipython-input-2-aee192733216> in <module>()
----> 1 df = pd.read_csv('score.csv')
~/anaconda3/envs/py36/lib/python3 …Category: data-wrangling
Read Moretitle: "Values and Index" author: "Rj" date: 2019-04-22 description: "-" type: technical_note draft: false
import numpy as np
import pandas as pd
datatype = [('one', 'int32'), ('two', 'int32')]
values = np.zeros(3, dtype = datatype)
currrent_index = ['Row '+str(i) for i in range(1, 4)]
df = pd.DataFrame(values, index = currrent_index)
df
Category: data-wrangling
Read More