16进制转换为10进制

二进制表示：前面加0b  例：0b10

八进制表示：前面加0o  例：0o10

十六进制表示：前面加0x  例：0x10

df_test.head()
Out[295]: 
   0000  0000.1  0000.2  0000.3  0000.4  ...  FF92  FFFC  0000.55  01B7  8E20
0     0       0       0       0       0  ...  FF92  FFFC        0  01B7  8E25
1     0       0       0       0       0  ...  FF91  FFFC        0  01B7  8E2A
2     0       0       0       0       0  ...  FF91  FFFC        0  01B7  8E2F
3     0       0       0       0       0  ...  FF92  FFFC        0  01B7  8E34
4     0       0       0       0       0  ...  FF92  FFFC        0  01B7  8E39

[5 rows x 93 columns]

df_test.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2772 entries, 0 to 2771
Data columns (total 93 columns):
0000       2772 non-null int64
0000.1     2772 non-null int64
0000.2     2772 non-null int64
0000.3     2772 non-null int64
0000.4     2772 non-null int64
0000.5     2772 non-null int64
0000.6     2772 non-null int64
0000.7     2772 non-null int64
0000.8     2772 non-null int64
0000.9     2772 non-null int64
0000.10    2772 non-null int64
0000.11    2772 non-null int64
0000.12    2772 non-null int64
0000.13    2772 non-null int64
0000.14    2772 non-null int64
0000.15    2772 non-null int64
0000.16    2772 non-null int64
0000.17    2772 non-null int64
FFCB       2772 non-null object
FC20       2772 non-null object
FFF8       2772 non-null object
0009       2772 non-null object
000A       2772 non-null object
01F7       2772 non-null object
0137       2772 non-null object
461B       2772 non-null object
06BD       2772 non-null object
0000.18    2772 non-null int64
0000.19    2772 non-null int64
0000.20    2772 non-null int64
0000.21    2772 non-null int64
0000.22    2772 non-null int64
0000.23    2772 non-null int64
0000.24    2772 non-null int64
0000.25    2772 non-null int64
0000.26    2772 non-null int64
03A2       2772 non-null object
016B       2772 non-null object
FFFF       2772 non-null object
0006       2772 non-null object
0002       2772 non-null object
E5FC       2772 non-null object
E520       2772 non-null object
0000.27    2772 non-null object
0001       2772 non-null object
0000.28    2772 non-null int64
0000.29    2772 non-null int64
0000.30    2772 non-null int64
0000.31    2772 non-null int64
0000.32    2772 non-null int64
0000.33    2772 non-null int64
0000.34    2772 non-null int64
0000.35    2772 non-null int64
0000.36    2772 non-null int64
FC5E       2772 non-null object
0159       2772 non-null object
0017       2772 non-null object
0007       2772 non-null object
FFFF.1     2772 non-null object
1BF6       2772 non-null object
1B0F       2772 non-null object
FE52       2772 non-null object
FFE3       2772 non-null object
0000.37    2772 non-null int64
0000.38    2772 non-null int64
0000.39    2772 non-null int64
0000.40    2772 non-null int64
0000.41    2772 non-null int64
0000.42    2772 non-null int64
0000.43    2772 non-null int64
0000.44    2772 non-null int64
0000.45    2772 non-null int64
0000.46    2772 non-null int64
0000.47    2772 non-null int64
0000.48    2772 non-null int64
0000.49    2772 non-null int64
0000.50    2772 non-null int64
0000.51    2772 non-null int64
0000.52    2772 non-null int64
0000.53    2772 non-null int64
0000.54    2772 non-null int64
FE42       2772 non-null object
FFF1       2772 non-null object
0369       2772 non-null object
FFF6       2772 non-null object
FFFF.2     2772 non-null object
0AFF       2772 non-null object
0A91       2772 non-null object
FF92       2772 non-null object
FFFC       2772 non-null object
0000.55    2772 non-null int64
01B7       2772 non-null object
8E20       2772 non-null object
dtypes: int64(55), object(38)
memory usage: 2.0+ MB

18:object
19:object
20:object
21:object
22:object
23:object
24:object
25:object
26:object
36:object
37:object
38:object
39:object
40:object
41:object
42:object
43:object
44:object
54:object
55:object
56:object
57:object
58:object
59:object
60:object
61:object
62:object
81:object
82:object
83:object
84:object
85:object
86:object
87:object
88:object
89:object

 

path = "G:/DAS/data/"
gdfc = GetDataFromCsv(path)
gdfc.read(mode='txt')
df_test = gdfc.df
list_tmp = list(df_test['data'])
df_test =list_tmp[0]

for i,dtype in enumerate(df_test.dtypes[:-2]):
    if dtype == np.dtype('object'):
        print("{}:{}".format(i,dtype))
        df_test.iloc[:,i] = df_test.iloc[:,i].apply(lambda x:int(x,16))

df_test.head()
Out[303]: 
   0000  0000.1  0000.2  0000.3  0000.4  ...   FF92   FFFC  0000.55  01B7  8E20
0     0       0       0       0       0  ...  65426  65532        0  01B7  8E25
1     0       0       0       0       0  ...  65425  65532        0  01B7  8E2A
2     0       0       0       0       0  ...  65425  65532        0  01B7  8E2F
3     0       0       0       0       0  ...  65426  65532        0  01B7  8E34
4     0       0       0       0       0  ...  65426  65532        0  01B7  8E39



91:object
92:object

 

进制转换

其他进制转二进制bin()

其他进制转八进制oct()

其他进制转十进制int()

其他进制转十六进制hex()