解码csv文件中的base64字符串

2024-03-28 09:25:57 发布

您现在位置:Python中文网/ 问答频道 /正文

import base64 

import csv

import pandas as pd

from pandas import read_csv

df = pd.read_csv('C:/Users/Lenovo/Desktop/실증 데이터/200921_obd_data/0004514.csv',
         
dtype = {"serial_number": str, "topic": str,"payload": str,"payload_type": str,"created": str})

df

payload_df = df['payload']

payload_df

words = pd.read_table('C:/Users/Lenovo/Desktop/실증 데이터/200921_obd_data/test.csv',names=['payload'], header=None, sep="\t")

words

data = base64.b64decode(words)

这是我的密码

最后一个参数是关于错误的

/---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-35-7232c7ca2a22> in <module>
----> 1 data = base64.b64decode(words)

~\anaconda3\lib\base64.py in b64decode(s, altchars, validate)
     78     in the input result in a binascii.Error.
     79     """
---> 80     s = _bytes_from_decode_data(s)
     81     if altchars is not None:
     82         altchars = _bytes_from_decode_data(altchars)

~\anaconda3\lib\base64.py in _bytes_from_decode_data(s)
     44     except TypeError:
     45         raise TypeError("argument should be a bytes-like object or ASCII "
---> 46                         "string, not %r" % s.__class__.__name__) from None
     47 
     48 

TypeError: argument should be a bytes-like object or ASCII string, not 'DataFrame'/

这个

我怎样才能把它修好

我有一个编码为base64的数据,所以我想对它进行解码


Tags: csvinfromimportdfreaddatabytes