pandas

读文件

import pandas as pd

df = pd.read_excel('data.xlsx')
df = pd.read_csv('data.csv')
df.columns.tolist()
merged_data = pd.merge(df_a, df_b, left_on='id', right_on='aid', how='inner')
df.drop('id', axis=1)
df = df[df['name'] == 'nnname']
df.to_excel('result.xlsx', index=False)
df.head()
df.groupby('callno')
df['name'].apply(lambda x: is_valid_text(x))
result = df['name'].copy()
faq_list = df['答案文本'].dropna().unique().tolist()
faq_list = df.iloc[:, 2].dropna().unique().tolist()
result_df = pd.DataFrame(results)
filtered_df = result_df[result_df['Q相似度得分'] > 90].copy()
result_df['Q相似度得分'].mean():.2f
filtered_df['更适合的答案'].value_counts().to_string()
merged = pd.merge(
    lx_grouped, 
    yx_grouped, 
    on=['intent', 'best_match'], 
    suffixes=('_lx', '_yx'),
    how='outer'
)
for _, row in merged.iterrows():
rows.append({})
df.values:
df.to_dict(orient='records')
list(df_e['会话id'])
df = df.sort_values(['callno', 'speake_no']).reset_index(drop=True)
df.sheet_names
df.count()