time.strftime将时间戳转换为时间格式时老师出错

邓文龙

1. import pandas as pd
   
2. import time
   
3. 
   
4. #数据导入
   
5. adminlogin=pd.read_json('mingxing97.adminlogin.json',lines=True)
   
6. #print(adminlogin.head())
   
7. #adminlogin.to_csv('mingxing97.adminlogin.csv')
   
8. #print(adminlogin.shape)
   
9. allplayers=pd.read_json('mingxing97.allplayers.json',lines=True)
   
10. #print(allplayers.head())
    
11. #
    
12. def timedate(df):
    
13.     df['date']=0
    
14.     for i in range(df.shape[0]):
    
15.           df['date'][i] = time.strftime("%Y--%m--%d",time.localtime(df.loc[:,['time']][i]))  
    
16. 
    
17. timedate(adminlogin)

复制代码

代码中的time是dataframe中的时间戳，

这是报错信息

1.    runfile('C:/Users/wendashuaige/Desktop/拉新数据/新建文件夹/拉新数据2.py', wdir='C:/Users/wendashuaige/Desktop/拉新数据/新建文件夹')
   
2. 
   
3.   File "C:\ProgramData\Anaconda3\lib\site-packages\spyder\utils\site\sitecustomize.py", line 710, in runfile
   
4.     execfile(filename, namespace)
   
5. 
   
6.   File "C:\ProgramData\Anaconda3\lib\site-packages\spyder\utils\site\sitecustomize.py", line 101, in execfile
   
7.     exec(compile(f.read(), filename, 'exec'), namespace)
   
8. 
   
9.   File "C:/Users/wendashuaige/Desktop/拉新数据/新建文件夹/拉新数据2.py", line 23, in <module>
   
10.     timedate(adminlogin)
    
11. 
    
12.   File "C:/Users/wendashuaige/Desktop/拉新数据/新建文件夹/拉新数据2.py", line 21, in timedate
    
13.     df['date'][i] = time.strptime("%Y--%m--%d",time.localtime(df.loc[:,['time']][i]))
    
14. 
    
15.   File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\frame.py", line 1964, in __getitem__
    
16.     return self._getitem_column(key)
    
17. 
    
18.   File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\frame.py", line 1971, in _getitem_column
    
19.     return self._get_item_cache(key)
    
20. 
    
21.   File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\generic.py", line 1645, in _get_item_cache
    
22.     values = self._data.get(item)
    
23. 
    
24.   File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\internals.py", line 3590, in get
    
25.     loc = self.items.get_loc(item)
    
26. 
    
27.   File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\indexes\base.py", line 2444, in get_loc
    
28.     return self._engine.get_loc(self._maybe_cast_indexer(key))
    
29. 
    
30.   File "pandas\_libs\index.pyx", line 132, in pandas._libs.index.IndexEngine.get_loc
    
31. 
    
32.   File "pandas\_libs\index.pyx", line 154, in pandas._libs.index.IndexEngine.get_loc
    
33. 
    
34.   File "pandas\_libs\hashtable_class_helper.pxi", line 1210, in pandas._libs.hashtable.PyObjectHashTable.get_item
    
35. 
    
36.   File "pandas\_libs\hashtable_class_helper.pxi", line 1218, in pandas._libs.hashtable.PyObjectHashTable.get_item
    
37. 
    
38. KeyError: 0

复制代码

我该怎么办啊

margret666

同问