代码aaaa-优快云博客

import chardet 
import pandas as pd
# 读取文件的前1024字节来检测编码  
with open('C:/Users/hao/Documents/WeChat Files/wxid_m1vqvekwcysa22/FileStorage/File/2024-09/CUMCM2024Problems/E题/附件2.csv', 'rb') as f:  
    rawdata = f.read(1024)  
    result = chardet.detect(rawdata)  
  
# 使用检测到的编码读取文件  
try:  
    df = pd.read_csv('C:/Users/hao/Documents/WeChat Files/wxid_m1vqvekwcysa22/FileStorage/File/2024-09/CUMCM2024Problems/E题/附件2.csv', encoding=result['encoding'])  
    print(f"成功使用 {result['encoding']} 编码读取文件")  
except Exception as e:  
    print(f"读取文件失败: {e}")
df['data']=[1]*8844996
df['data']=df['时间'].str[0:10]
df['time']=df['时间'].str[11:13]
df.groupby('data').size()
df.groupby('time').size()
df = df[df['交叉口'] == '经中路-纬中路'] 
df.groupby(['方向']).size()
df.groupby(['time']).size()
df1=df[df['方向']==1]
df2=df[df['方向']==2]
df3=df[df['方向']==3]
df4=df[df['方向']==4]
df1.to_csv('D:/桌面/东_西.csv', index=False)  
df2.to_csv('D:/桌面/西_东.csv', index=False)  
df3.to_csv('D:/桌面/南_北.csv', index=False) 
df4.to_csv('D:/桌面/北_南.csv', index=False)