{"id":61,"date":"2026-05-13T01:35:48","date_gmt":"2026-05-12T17:35:48","guid":{"rendered":"http:\/\/w.renho.local\/?p=61"},"modified":"2026-05-13T01:35:48","modified_gmt":"2026-05-12T17:35:48","slug":"pandas","status":"publish","type":"post","link":"https:\/\/www.devfm.cn\/?p=61","title":{"rendered":"pandas"},"content":{"rendered":"<h2>\u8bfb\u6587\u4ef6<\/h2>\n<pre><code class=\"language-python line-numbers\">import pandas as pd\n\ndf = pd.read_excel('data.xlsx')\ndf = pd.read_csv('data.csv')\ndf.columns.tolist()\nmerged_data = pd.merge(df_a, df_b, left_on='id', right_on='aid', how='inner')\ndf.drop('id', axis=1)\ndf = df[df['name'] == 'nnname']\ndf.to_excel('result.xlsx', index=False)\ndf.head()\ndf.groupby('callno')\ndf['name'].apply(lambda x: is_valid_text(x))\nresult = df['name'].copy()\nfaq_list = df['\u7b54\u6848\u6587\u672c'].dropna().unique().tolist()\nfaq_list = df.iloc[:, 2].dropna().unique().tolist()\nresult_df = pd.DataFrame(results)\nfiltered_df = result_df[result_df['Q\u76f8\u4f3c\u5ea6\u5f97\u5206'] &gt; 90].copy()\nresult_df['Q\u76f8\u4f3c\u5ea6\u5f97\u5206'].mean():.2f\nfiltered_df['\u66f4\u9002\u5408\u7684\u7b54\u6848'].value_counts().to_string()\nmerged = pd.merge(\n    lx_grouped, \n    yx_grouped, \n    on=['intent', 'best_match'], \n    suffixes=('_lx', '_yx'),\n    how='outer'\n)\nfor _, row in merged.iterrows():\nrows.append({})\ndf.values:\ndf.to_dict(orient='records')\nlist(df_e['\u4f1a\u8bddid'])\ndf = df.sort_values(['callno', 'speake_no']).reset_index(drop=True)\ndf.sheet_names\ndf.count()\n\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u8bfb\u6587\u4ef6 import pandas as pd df = pd.read_excel(&#8216;data.xlsx&#8217;)&hellip; <a class=\"read-more-link\" href=\"https:\/\/www.devfm.cn\/?p=61\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-61","post","type-post","status-publish","format-standard","hentry","category-python"],"_links":{"self":[{"href":"https:\/\/www.devfm.cn\/index.php?rest_route=\/wp\/v2\/posts\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devfm.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devfm.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devfm.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devfm.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=61"}],"version-history":[{"count":1,"href":"https:\/\/www.devfm.cn\/index.php?rest_route=\/wp\/v2\/posts\/61\/revisions"}],"predecessor-version":[{"id":62,"href":"https:\/\/www.devfm.cn\/index.php?rest_route=\/wp\/v2\/posts\/61\/revisions\/62"}],"wp:attachment":[{"href":"https:\/\/www.devfm.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devfm.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devfm.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}