最简单的XML格式Excel表格文件
csv、xls、xlsx、文件通过 JavaScript 解析成为 JSON 数据 - DZMFormJson
本文章已封装成库，直接使用即可 DZMExcelDownload，支持前端原生或 Vue 等框架使用。
支持 单元格样式，合并单元格。
二、 DZMExcelDownload 使用
Document</t......
<span class="show-more" data-v-81320aca="">
查看更多
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-1837452791782084"
data-ad-slot="7041996284"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</span>
<div class="title-row" data-v-81320aca="">
<a class="title" data-v-81320aca="" href="/post/6885535474501304334" rel="" target="_blank" title="JS 将数据保存为 Excel（xls、xlsx）文件，支持单元格样式，合并单元格">
JS 将数据保存为 Excel（xls、xlsx）文件，支持单元格样式，合并单元格
</a>
</div>
<div class="meta-container" data-v-81320aca="">
<a class="user-message" data-v-81320aca="" href="/user/4450440831840909" rel="" target="_blank">
</a>
<div class="popover-box user-popover" data-v-4b48f267="" data-v-81320aca="" data-v-e0fd52c2="">
<a class="user-message" data-v-81320aca="" href="/user/4450440831840909" rel="" target="_blank">
<!---->
JavaScript
Node.js
</a>
</div>
</div>
<div class="content-wrapper" data-v-a8958c90="" style="border-bottom:1px solid rgba(228, 230, 235, 0.5);">
<div class="content-main" data-v-a8958c90="">
<div class="title-row" data-v-a8958c90="">
<!---->
<!---->
<!---->
<a class="title" data-v-a8958c90="" href="/post/7088273882179698719" rel="" target="_blank" title="将 ProcessOn 的思维导图转化为 Excel">
将 ProcessOn 的思维导图转化为 Excel
</a>
</div>
<div class="abstract" data-v-a8958c90="">
<a data-v-a8958c90="" href="/post/7088273882179698719" rel="" target="_blank">
<div data-v-a8958c90="">
一、技术背景 需要将一个 processOn 的思维导图转化到 Excel 表格中，方法有两个：第一，我们可以直接按照思维导图的结构，按照规则一个个填写到 Excel 中，合并单元格；第二，写个工具，
</div>
</a>
</div>
<ul class="action-list jh-timeline-action-area" data-v-a8958c90="">
<li class="item view" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="view-icon" data-v-a8958c90="" fill="none" height="16" viewBox="0 0 16 16" width="16">
<path d="M7.90078 2.80078C4.49278 2.80078 1.74745 6.11672 0.800781 7.77469C1.74745 9.58339 4.49278 13.2008 7.90078 13.2008C11.3088 13.2008 14.0541 9.58339 15.0008 7.77469C14.0541 6.11672 11.3088 2.80078 7.90078 2.80078Z" data-v-a8958c90="" stroke="currentColor">
</path>
<circle cx="7.89922" cy="8.00078" data-v-a8958c90="" r="2.2" stroke="currentColor">
</circle>
</svg>
<span data-v-a8958c90="">
372
</span>
</li>
<li class="item like" data-v-a8958c90="">
<div class="liked-wrap" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="liked-icon" data-v-a8958c90="" fill="none" height="14" viewBox="0 0 14 14" width="14">
<path clip-rule="evenodd" d="M7.56162 1.16952C7.66569 1.09661 7.78195 1.06124 7.88247 1.0912C7.97653 1.11923 8.23851 1.25916 8.50988 1.96799C8.64419 2.31881 8.9356 3.2424 8.42155 5.05431C8.29751 5.49152 8.61394 5.95303 9.09259 5.95971L12.492 6.00716L12.492 6.00721H12.4991C12.6049 6.00721 12.7228 6.01986 12.8134 6.05898C12.8544 6.07671 12.8815 6.09639 12.8999 6.116C12.9166 6.13375 12.9368 6.16247 12.9515 6.21636C12.9848 6.33784 13.0228 6.74712 12.9473 7.42262C12.874 8.07857 12.698 8.94479 12.341 9.9598C12.0424 10.8088 11.6601 11.5292 11.0684 12.4879C11.0558 12.5052 11.0462 12.5197 11.0418 12.5265L11.0404 12.5285C11.0292 12.5454 11.0242 12.5531 11.018 12.5618C11.0076 12.5764 11.0018 12.582 10.9983 12.585C10.996 12.587 10.9908 12.5912 10.9777 12.5959C10.9638 12.6009 10.9311 12.61 10.8706 12.61H4.56278L4.56373 5.58489C4.87126 5.41901 5.19881 5.20128 5.54112 4.84059C5.93883 4.42152 6.33789 3.8294 6.76254 2.94183C6.84974 2.75957 6.91745 2.55962 6.97574 2.37762C6.99264 2.32486 7.0087 2.27379 7.02438 2.22393L7.02439 2.22389C7.066 2.09158 7.10495 1.96776 7.14985 1.84312C7.2758 1.49352 7.40247 1.28101 7.56162 1.16952ZM9.45205 1.60729C9.13229 0.772086 8.70208 0.282772 8.17063 0.124374C7.64564 -0.0320981 7.20308 0.188912 6.98278 0.343248C6.55169 0.64525 6.33837 1.11908 6.20071 1.5012C6.14817 1.64705 6.10002 1.80016 6.05661 1.93824C6.0422 1.98405 6.02832 2.02821 6.01496 2.0699C5.95791 2.24804 5.90763 2.39115 5.85248 2.50643C5.45683 3.3334 5.1121 3.8271 4.80935 4.14611C4.51322 4.45815 4.23983 4.6219 3.9473 4.76821C3.71095 4.88641 3.55494 5.12906 3.55491 5.40159L3.55388 12.9125C3.55383 13.3026 3.87002 13.6188 4.26008 13.6188H10.8706C11.2097 13.6188 11.4663 13.5113 11.6519 13.3535C11.7387 13.2797 11.7988 13.2043 11.8387 13.1484C11.8556 13.1248 11.8704 13.1025 11.8786 13.09L11.8813 13.0859L11.8826 13.0839L11.8955 13.0685L11.9142 13.0382C12.5304 12.0414 12.9578 11.247 13.2927 10.2945C13.6745 9.20895 13.8679 8.26811 13.9499 7.5347C14.0297 6.82084 14.009 6.25845 13.9246 5.95014C13.805 5.51285 13.5104 5.26112 13.2134 5.13284C12.9385 5.01407 12.661 4.99859 12.5028 4.99836L9.49071 4.95631C9.92962 3.15791 9.64796 2.11902 9.45205 1.60729ZM0.000800636 5.46783C-0.0181914 5.0652 0.303128 4.72836 0.706212 4.72836H1.75264C2.14266 4.72836 2.45883 5.04454 2.45883 5.43456V12.9442C2.45883 13.3342 2.14266 13.6504 1.75264 13.6504H1.06044C0.68335 13.6504 0.372791 13.3541 0.355024 12.9775L0.000800636 5.46783Z" data-v-a8958c90="" fill="currentColor" fill-rule="evenodd">
</path>
</svg>
</div>
<span data-v-a8958c90="">
okokabcd
Excel
</span>
</li>
</ul>
</div>
</div>
<div class="content-wrapper" data-v-a8958c90="" style="border-bottom:1px solid rgba(228, 230, 235, 0.5);">
<div class="content-main" data-v-a8958c90="">
<div class="title-row" data-v-a8958c90="">
<!---->
<!---->
<!---->
<a class="title" data-v-a8958c90="" href="/post/6844903972671586318" rel="" target="_blank" title="Excel快速填充一列">
Excel快速填充一列
</a>
</div>
<div class="abstract" data-v-a8958c90="">
<a data-v-a8958c90="" href="/post/6844903972671586318" rel="" target="_blank">
<div data-v-a8958c90="">
在该列第一行中填写要填充的数据选中一列 Ctrl+Shift+ 向下方向键按Ctrl+D，实现填充选中多列的话，就会填充多列
</div>
</a>
</div>
<ul class="action-list jh-timeline-action-area" data-v-a8958c90="">
<li class="item view" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="view-icon" data-v-a8958c90="" fill="none" height="16" viewBox="0 0 16 16" width="16">
<path d="M7.90078 2.80078C4.49278 2.80078 1.74745 6.11672 0.800781 7.77469C1.74745 9.58339 4.49278 13.2008 7.90078 13.2008C11.3088 13.2008 14.0541 9.58339 15.0008 7.77469C14.0541 6.11672 11.3088 2.80078 7.90078 2.80078Z" data-v-a8958c90="" stroke="currentColor">
</path>
<circle cx="7.89922" cy="8.00078" data-v-a8958c90="" r="2.2" stroke="currentColor">
</circle>
</svg>
<span data-v-a8958c90="">
2883
</span>
</li>
<li class="item like" data-v-a8958c90="">
<div class="liked-wrap" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="liked-icon" data-v-a8958c90="" fill="none" height="14" viewBox="0 0 14 14" width="14">
<path clip-rule="evenodd" d="M7.56162 1.16952C7.66569 1.09661 7.78195 1.06124 7.88247 1.0912C7.97653 1.11923 8.23851 1.25916 8.50988 1.96799C8.64419 2.31881 8.9356 3.2424 8.42155 5.05431C8.29751 5.49152 8.61394 5.95303 9.09259 5.95971L12.492 6.00716L12.492 6.00721H12.4991C12.6049 6.00721 12.7228 6.01986 12.8134 6.05898C12.8544 6.07671 12.8815 6.09639 12.8999 6.116C12.9166 6.13375 12.9368 6.16247 12.9515 6.21636C12.9848 6.33784 13.0228 6.74712 12.9473 7.42262C12.874 8.07857 12.698 8.94479 12.341 9.9598C12.0424 10.8088 11.6601 11.5292 11.0684 12.4879C11.0558 12.5052 11.0462 12.5197 11.0418 12.5265L11.0404 12.5285C11.0292 12.5454 11.0242 12.5531 11.018 12.5618C11.0076 12.5764 11.0018 12.582 10.9983 12.585C10.996 12.587 10.9908 12.5912 10.9777 12.5959C10.9638 12.6009 10.9311 12.61 10.8706 12.61H4.56278L4.56373 5.58489C4.87126 5.41901 5.19881 5.20128 5.54112 4.84059C5.93883 4.42152 6.33789 3.8294 6.76254 2.94183C6.84974 2.75957 6.91745 2.55962 6.97574 2.37762C6.99264 2.32486 7.0087 2.27379 7.02438 2.22393L7.02439 2.22389C7.066 2.09158 7.10495 1.96776 7.14985 1.84312C7.2758 1.49352 7.40247 1.28101 7.56162 1.16952ZM9.45205 1.60729C9.13229 0.772086 8.70208 0.282772 8.17063 0.124374C7.64564 -0.0320981 7.20308 0.188912 6.98278 0.343248C6.55169 0.64525 6.33837 1.11908 6.20071 1.5012C6.14817 1.64705 6.10002 1.80016 6.05661 1.93824C6.0422 1.98405 6.02832 2.02821 6.01496 2.0699C5.95791 2.24804 5.90763 2.39115 5.85248 2.50643C5.45683 3.3334 5.1121 3.8271 4.80935 4.14611C4.51322 4.45815 4.23983 4.6219 3.9473 4.76821C3.71095 4.88641 3.55494 5.12906 3.55491 5.40159L3.55388 12.9125C3.55383 13.3026 3.87002 13.6188 4.26008 13.6188H10.8706C11.2097 13.6188 11.4663 13.5113 11.6519 13.3535C11.7387 13.2797 11.7988 13.2043 11.8387 13.1484C11.8556 13.1248 11.8704 13.1025 11.8786 13.09L11.8813 13.0859L11.8826 13.0839L11.8955 13.0685L11.9142 13.0382C12.5304 12.0414 12.9578 11.247 13.2927 10.2945C13.6745 9.20895 13.8679 8.26811 13.9499 7.5347C14.0297 6.82084 14.009 6.25845 13.9246 5.95014C13.805 5.51285 13.5104 5.26112 13.2134 5.13284C12.9385 5.01407 12.661 4.99859 12.5028 4.99836L9.49071 4.95631C9.92962 3.15791 9.64796 2.11902 9.45205 1.60729ZM0.000800636 5.46783C-0.0181914 5.0652 0.303128 4.72836 0.706212 4.72836H1.75264C2.14266 4.72836 2.45883 5.04454 2.45883 5.43456V12.9442C2.45883 13.3342 2.14266 13.6504 1.75264 13.6504H1.06044C0.68335 13.6504 0.372791 13.3541 0.355024 12.9775L0.000800636 5.46783Z" data-v-a8958c90="" fill="currentColor" fill-rule="evenodd">
</path>
</svg>
</div>
<span data-v-a8958c90="">
solocoder
Excel
Ant Design
</span>
</li>
</ul>
</div>
</div>
<div class="content-wrapper" data-v-a8958c90="" style="border-bottom:1px solid rgba(228, 230, 235, 0.5);">
<div class="content-main" data-v-a8958c90="">
<div class="title-row" data-v-a8958c90="">
<!---->
<!---->
<!---->
<a class="title" data-v-a8958c90="" href="/post/7071882317953761316" rel="" target="_blank" title="前端复杂表格导出excel，一键导出 Antd Table 看这篇就够了（附源码）">
前端复杂表格导出excel，一键导出 Antd Table 看这篇就够了（附源码）
</a>
</div>
<div class="abstract" data-v-a8958c90="">
<a data-v-a8958c90="" href="/post/7071882317953761316" rel="" target="_blank">
<div data-v-a8958c90="">
前端导出 excel 的需求很多，但市面上好用的库并不多，讲明白复杂使用场景的文章更少。 本文将以文字 + demo 源码的形式，力求讲清楚满足 99% 使用场景的终极 excel 导出方案。 如果项
</div>
</a>
</div>
<ul class="action-list jh-timeline-action-area" data-v-a8958c90="">
<li class="item view" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="view-icon" data-v-a8958c90="" fill="none" height="16" viewBox="0 0 16 16" width="16">
<path d="M7.90078 2.80078C4.49278 2.80078 1.74745 6.11672 0.800781 7.77469C1.74745 9.58339 4.49278 13.2008 7.90078 13.2008C11.3088 13.2008 14.0541 9.58339 15.0008 7.77469C14.0541 6.11672 11.3088 2.80078 7.90078 2.80078Z" data-v-a8958c90="" stroke="currentColor">
</path>
<circle cx="7.89922" cy="8.00078" data-v-a8958c90="" r="2.2" stroke="currentColor">
</circle>
</svg>
<span data-v-a8958c90="">
5465
</span>
</li>
<li class="item like" data-v-a8958c90="">
<div class="liked-wrap" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="liked-icon" data-v-a8958c90="" fill="none" height="14" viewBox="0 0 14 14" width="14">
<path clip-rule="evenodd" d="M7.56162 1.16952C7.66569 1.09661 7.78195 1.06124 7.88247 1.0912C7.97653 1.11923 8.23851 1.25916 8.50988 1.96799C8.64419 2.31881 8.9356 3.2424 8.42155 5.05431C8.29751 5.49152 8.61394 5.95303 9.09259 5.95971L12.492 6.00716L12.492 6.00721H12.4991C12.6049 6.00721 12.7228 6.01986 12.8134 6.05898C12.8544 6.07671 12.8815 6.09639 12.8999 6.116C12.9166 6.13375 12.9368 6.16247 12.9515 6.21636C12.9848 6.33784 13.0228 6.74712 12.9473 7.42262C12.874 8.07857 12.698 8.94479 12.341 9.9598C12.0424 10.8088 11.6601 11.5292 11.0684 12.4879C11.0558 12.5052 11.0462 12.5197 11.0418 12.5265L11.0404 12.5285C11.0292 12.5454 11.0242 12.5531 11.018 12.5618C11.0076 12.5764 11.0018 12.582 10.9983 12.585C10.996 12.587 10.9908 12.5912 10.9777 12.5959C10.9638 12.6009 10.9311 12.61 10.8706 12.61H4.56278L4.56373 5.58489C4.87126 5.41901 5.19881 5.20128 5.54112 4.84059C5.93883 4.42152 6.33789 3.8294 6.76254 2.94183C6.84974 2.75957 6.91745 2.55962 6.97574 2.37762C6.99264 2.32486 7.0087 2.27379 7.02438 2.22393L7.02439 2.22389C7.066 2.09158 7.10495 1.96776 7.14985 1.84312C7.2758 1.49352 7.40247 1.28101 7.56162 1.16952ZM9.45205 1.60729C9.13229 0.772086 8.70208 0.282772 8.17063 0.124374C7.64564 -0.0320981 7.20308 0.188912 6.98278 0.343248C6.55169 0.64525 6.33837 1.11908 6.20071 1.5012C6.14817 1.64705 6.10002 1.80016 6.05661 1.93824C6.0422 1.98405 6.02832 2.02821 6.01496 2.0699C5.95791 2.24804 5.90763 2.39115 5.85248 2.50643C5.45683 3.3334 5.1121 3.8271 4.80935 4.14611C4.51322 4.45815 4.23983 4.6219 3.9473 4.76821C3.71095 4.88641 3.55494 5.12906 3.55491 5.40159L3.55388 12.9125C3.55383 13.3026 3.87002 13.6188 4.26008 13.6188H10.8706C11.2097 13.6188 11.4663 13.5113 11.6519 13.3535C11.7387 13.2797 11.7988 13.2043 11.8387 13.1484C11.8556 13.1248 11.8704 13.1025 11.8786 13.09L11.8813 13.0859L11.8826 13.0839L11.8955 13.0685L11.9142 13.0382C12.5304 12.0414 12.9578 11.247 13.2927 10.2945C13.6745 9.20895 13.8679 8.26811 13.9499 7.5347C14.0297 6.82084 14.009 6.25845 13.9246 5.95014C13.805 5.51285 13.5104 5.26112 13.2134 5.13284C12.9385 5.01407 12.661 4.99859 12.5028 4.99836L9.49071 4.95631C9.92962 3.15791 9.64796 2.11902 9.45205 1.60729ZM0.000800636 5.46783C-0.0181914 5.0652 0.303128 4.72836 0.706212 4.72836H1.75264C2.14266 4.72836 2.45883 5.04454 2.45883 5.43456V12.9442C2.45883 13.3342 2.14266 13.6504 1.75264 13.6504H1.06044C0.68335 13.6504 0.372791 13.3541 0.355024 12.9775L0.000800636 5.46783Z" data-v-a8958c90="" fill="currentColor" fill-rule="evenodd">
</path>
</svg>
</div>
<span data-v-a8958c90="">
不思量自难忘
Python
</span>
</li>
</ul>
</div>
</div>
<div class="content-wrapper" data-v-a8958c90="" style="border-bottom:1px solid rgba(228, 230, 235, 0.5);">
<div class="content-main" data-v-a8958c90="">
<div class="title-row" data-v-a8958c90="">
<!---->
<!---->
<!---->
<a class="title" data-v-a8958c90="" href="/post/6993518513977557005" rel="" target="_blank" title="pandas系列之数据分组（一）按照列名分组">
pandas系列之数据分组（一）按照列名分组
</a>
</div>
<div class="abstract" data-v-a8958c90="">
<a data-v-a8958c90="" href="/post/6993518513977557005" rel="" target="_blank">
<div data-v-a8958c90="">
这是pandas系列第三十篇，主要讲述了数据分组相关的知识。大体包括按一列分组、按多列分组、分组和聚合按照不同的列进行这3方面的内容
</div>
</a>
</div>
<ul class="action-list jh-timeline-action-area" data-v-a8958c90="">
<li class="item view" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="view-icon" data-v-a8958c90="" fill="none" height="16" viewBox="0 0 16 16" width="16">
<path d="M7.90078 2.80078C4.49278 2.80078 1.74745 6.11672 0.800781 7.77469C1.74745 9.58339 4.49278 13.2008 7.90078 13.2008C11.3088 13.2008 14.0541 9.58339 15.0008 7.77469C14.0541 6.11672 11.3088 2.80078 7.90078 2.80078Z" data-v-a8958c90="" stroke="currentColor">
</path>
<circle cx="7.89922" cy="8.00078" data-v-a8958c90="" r="2.2" stroke="currentColor">
</circle>
</svg>
<span data-v-a8958c90="">
2377
</span>
</li>
<li class="item like" data-v-a8958c90="">
<div class="liked-wrap" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="liked-icon" data-v-a8958c90="" fill="none" height="14" viewBox="0 0 14 14" width="14">
<path clip-rule="evenodd" d="M7.56162 1.16952C7.66569 1.09661 7.78195 1.06124 7.88247 1.0912C7.97653 1.11923 8.23851 1.25916 8.50988 1.96799C8.64419 2.31881 8.9356 3.2424 8.42155 5.05431C8.29751 5.49152 8.61394 5.95303 9.09259 5.95971L12.492 6.00716L12.492 6.00721H12.4991C12.6049 6.00721 12.7228 6.01986 12.8134 6.05898C12.8544 6.07671 12.8815 6.09639 12.8999 6.116C12.9166 6.13375 12.9368 6.16247 12.9515 6.21636C12.9848 6.33784 13.0228 6.74712 12.9473 7.42262C12.874 8.07857 12.698 8.94479 12.341 9.9598C12.0424 10.8088 11.6601 11.5292 11.0684 12.4879C11.0558 12.5052 11.0462 12.5197 11.0418 12.5265L11.0404 12.5285C11.0292 12.5454 11.0242 12.5531 11.018 12.5618C11.0076 12.5764 11.0018 12.582 10.9983 12.585C10.996 12.587 10.9908 12.5912 10.9777 12.5959C10.9638 12.6009 10.9311 12.61 10.8706 12.61H4.56278L4.56373 5.58489C4.87126 5.41901 5.19881 5.20128 5.54112 4.84059C5.93883 4.42152 6.33789 3.8294 6.76254 2.94183C6.84974 2.75957 6.91745 2.55962 6.97574 2.37762C6.99264 2.32486 7.0087 2.27379 7.02438 2.22393L7.02439 2.22389C7.066 2.09158 7.10495 1.96776 7.14985 1.84312C7.2758 1.49352 7.40247 1.28101 7.56162 1.16952ZM9.45205 1.60729C9.13229 0.772086 8.70208 0.282772 8.17063 0.124374C7.64564 -0.0320981 7.20308 0.188912 6.98278 0.343248C6.55169 0.64525 6.33837 1.11908 6.20071 1.5012C6.14817 1.64705 6.10002 1.80016 6.05661 1.93824C6.0422 1.98405 6.02832 2.02821 6.01496 2.0699C5.95791 2.24804 5.90763 2.39115 5.85248 2.50643C5.45683 3.3334 5.1121 3.8271 4.80935 4.14611C4.51322 4.45815 4.23983 4.6219 3.9473 4.76821C3.71095 4.88641 3.55494 5.12906 3.55491 5.40159L3.55388 12.9125C3.55383 13.3026 3.87002 13.6188 4.26008 13.6188H10.8706C11.2097 13.6188 11.4663 13.5113 11.6519 13.3535C11.7387 13.2797 11.7988 13.2043 11.8387 13.1484C11.8556 13.1248 11.8704 13.1025 11.8786 13.09L11.8813 13.0859L11.8826 13.0839L11.8955 13.0685L11.9142 13.0382C12.5304 12.0414 12.9578 11.247 13.2927 10.2945C13.6745 9.20895 13.8679 8.26811 13.9499 7.5347C14.0297 6.82084 14.009 6.25845 13.9246 5.95014C13.805 5.51285 13.5104 5.26112 13.2134 5.13284C12.9385 5.01407 12.661 4.99859 12.5028 4.99836L9.49071 4.95631C9.92962 3.15791 9.64796 2.11902 9.45205 1.60729ZM0.000800636 5.46783C-0.0181914 5.0652 0.303128 4.72836 0.706212 4.72836H1.75264C2.14266 4.72836 2.45883 5.04454 2.45883 5.43456V12.9442C2.45883 13.3342 2.14266 13.6504 1.75264 13.6504H1.06044C0.68335 13.6504 0.372791 13.3541 0.355024 12.9775L0.000800636 5.46783Z" data-v-a8958c90="" fill="currentColor" fill-rule="evenodd">
</path>
</svg>
</div>
<span data-v-a8958c90="">
</span>
</li>
</ul>
</div>
<div class="date" data-v-a8958c90="">
5年前
</div>
<!---->
</div>
<div class="content-wrapper" data-v-a8958c90="" style="border-bottom:1px solid rgba(228, 230, 235, 0.5);">
<div class="content-main" data-v-a8958c90="">
<div class="title-row" data-v-a8958c90="">
<!---->
<!---->
<!---->
<a class="title" data-v-a8958c90="" href="/post/6844903555476750350" rel="" target="_blank" title="如何将多个CSV文件合并为一个">
如何将多个CSV文件合并为一个
</a>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<ins class="adsbygoogle"
style="display:block; text-align:center;"
data-ad-layout="in-article"
data-ad-format="fluid"
data-ad-client="ca-pub-1837452791782084"
data-ad-slot="7041996284"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div>
<div class="abstract" data-v-a8958c90="">
<a data-v-a8958c90="" href="/post/6844903555476750350" rel="" target="_blank">
<div data-v-a8958c90="">
将数据保存在CSV文件中通常非常方便，你可以随时用任何文本编辑器打开文件并调整它。但是如果在一个文件中你有引用另一个文件的数据呢？你需要将两个文件合并为一个文件，以方便进一步使用CSV文件。要手动完成合并是一件费力不讨好的工作，当然你也可以使用Excel – 这需要你对“宏”有…
</div>
</a>
</div>
<ul class="action-list jh-timeline-action-area" data-v-a8958c90="">
<li class="item view" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="view-icon" data-v-a8958c90="" fill="none" height="16" viewBox="0 0 16 16" width="16">
<path d="M7.90078 2.80078C4.49278 2.80078 1.74745 6.11672 0.800781 7.77469C1.74745 9.58339 4.49278 13.2008 7.90078 13.2008C11.3088 13.2008 14.0541 9.58339 15.0008 7.77469C14.0541 6.11672 11.3088 2.80078 7.90078 2.80078Z" data-v-a8958c90="" stroke="currentColor">
</path>
<circle cx="7.89922" cy="8.00078" data-v-a8958c90="" r="2.2" stroke="currentColor">
</circle>
</svg>
<span data-v-a8958c90="">
982
</span>
</li>
<li class="item like" data-v-a8958c90="">
<div class="liked-wrap" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="liked-icon" data-v-a8958c90="" fill="none" height="14" viewBox="0 0 14 14" width="14">
<path clip-rule="evenodd" d="M7.56162 1.16952C7.66569 1.09661 7.78195 1.06124 7.88247 1.0912C7.97653 1.11923 8.23851 1.25916 8.50988 1.96799C8.64419 2.31881 8.9356 3.2424 8.42155 5.05431C8.29751 5.49152 8.61394 5.95303 9.09259 5.95971L12.492 6.00716L12.492 6.00721H12.4991C12.6049 6.00721 12.7228 6.01986 12.8134 6.05898C12.8544 6.07671 12.8815 6.09639 12.8999 6.116C12.9166 6.13375 12.9368 6.16247 12.9515 6.21636C12.9848 6.33784 13.0228 6.74712 12.9473 7.42262C12.874 8.07857 12.698 8.94479 12.341 9.9598C12.0424 10.8088 11.6601 11.5292 11.0684 12.4879C11.0558 12.5052 11.0462 12.5197 11.0418 12.5265L11.0404 12.5285C11.0292 12.5454 11.0242 12.5531 11.018 12.5618C11.0076 12.5764 11.0018 12.582 10.9983 12.585C10.996 12.587 10.9908 12.5912 10.9777 12.5959C10.9638 12.6009 10.9311 12.61 10.8706 12.61H4.56278L4.56373 5.58489C4.87126 5.41901 5.19881 5.20128 5.54112 4.84059C5.93883 4.42152 6.33789 3.8294 6.76254 2.94183C6.84974 2.75957 6.91745 2.55962 6.97574 2.37762C6.99264 2.32486 7.0087 2.27379 7.02438 2.22393L7.02439 2.22389C7.066 2.09158 7.10495 1.96776 7.14985 1.84312C7.2758 1.49352 7.40247 1.28101 7.56162 1.16952ZM9.45205 1.60729C9.13229 0.772086 8.70208 0.282772 8.17063 0.124374C7.64564 -0.0320981 7.20308 0.188912 6.98278 0.343248C6.55169 0.64525 6.33837 1.11908 6.20071 1.5012C6.14817 1.64705 6.10002 1.80016 6.05661 1.93824C6.0422 1.98405 6.02832 2.02821 6.01496 2.0699C5.95791 2.24804 5.90763 2.39115 5.85248 2.50643C5.45683 3.3334 5.1121 3.8271 4.80935 4.14611C4.51322 4.45815 4.23983 4.6219 3.9473 4.76821C3.71095 4.88641 3.55494 5.12906 3.55491 5.40159L3.55388 12.9125C3.55383 13.3026 3.87002 13.6188 4.26008 13.6188H10.8706C11.2097 13.6188 11.4663 13.5113 11.6519 13.3535C11.7387 13.2797 11.7988 13.2043 11.8387 13.1484C11.8556 13.1248 11.8704 13.1025 11.8786 13.09L11.8813 13.0859L11.8826 13.0839L11.8955 13.0685L11.9142 13.0382C12.5304 12.0414 12.9578 11.247 13.2927 10.2945C13.6745 9.20895 13.8679 8.26811 13.9499 7.5347C14.0297 6.82084 14.009 6.25845 13.9246 5.95014C13.805 5.51285 13.5104 5.26112 13.2134 5.13284C12.9385 5.01407 12.661 4.99859 12.5028 4.99836L9.49071 4.95631C9.92962 3.15791 9.64796 2.11902 9.45205 1.60729ZM0.000800636 5.46783C-0.0181914 5.0652 0.303128 4.72836 0.706212 4.72836H1.75264C2.14266 4.72836 2.45883 5.04454 2.45883 5.43456V12.9442C2.45883 13.3342 2.14266 13.6504 1.75264 13.6504H1.06044C0.68335 13.6504 0.372791 13.3541 0.355024 12.9775L0.000800636 5.46783Z" data-v-a8958c90="" fill="currentColor" fill-rule="evenodd">
</path>
</svg>
</div>
<span data-v-a8958c90="">
程序员小C
Python
</span>
</li>
</ul>
</div>
</div>
<div class="content-wrapper" data-v-a8958c90="" style="border-bottom:1px solid rgba(228, 230, 235, 0.5);">
<div class="content-main" data-v-a8958c90="">
<div class="title-row" data-v-a8958c90="">
<!---->
<!---->
<!---->
<a class="title" data-v-a8958c90="" href="/post/7046934878528634888" rel="" target="_blank" title="教你如果用Python批量实现在Excel后里面新加一列，并且内容为excel 表名（附源码）">
教你如果用Python批量实现在Excel后里面新加一列，并且内容为excel 表名（附源码）
</a>
</div>
<div class="abstract" data-v-a8958c90="">
<a data-v-a8958c90="" href="/post/7046934878528634888" rel="" target="_blank">
<div data-v-a8958c90="">
如果是按照常规思路，首先打开一个Excel表格，之后在表格的最后一列添加对应表名，如果只是一个表格，表格内容只有一行的话，这么操作，三下五除二就完活了。但是如果遇到很多个表格，如果再这样逐个处理，就非
</div>
</a>
</div>
<ul class="action-list jh-timeline-action-area" data-v-a8958c90="">
<li class="item view" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="view-icon" data-v-a8958c90="" fill="none" height="16" viewBox="0 0 16 16" width="16">
<path d="M7.90078 2.80078C4.49278 2.80078 1.74745 6.11672 0.800781 7.77469C1.74745 9.58339 4.49278 13.2008 7.90078 13.2008C11.3088 13.2008 14.0541 9.58339 15.0008 7.77469C14.0541 6.11672 11.3088 2.80078 7.90078 2.80078Z" data-v-a8958c90="" stroke="currentColor">
</path>
<circle cx="7.89922" cy="8.00078" data-v-a8958c90="" r="2.2" stroke="currentColor">
</circle>
</svg>
<span data-v-a8958c90="">
571
</span>
</li>
<li class="item like" data-v-a8958c90="">
<div class="liked-wrap" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="liked-icon" data-v-a8958c90="" fill="none" height="14" viewBox="0 0 14 14" width="14">
<path clip-rule="evenodd" d="M7.56162 1.16952C7.66569 1.09661 7.78195 1.06124 7.88247 1.0912C7.97653 1.11923 8.23851 1.25916 8.50988 1.96799C8.64419 2.31881 8.9356 3.2424 8.42155 5.05431C8.29751 5.49152 8.61394 5.95303 9.09259 5.95971L12.492 6.00716L12.492 6.00721H12.4991C12.6049 6.00721 12.7228 6.01986 12.8134 6.05898C12.8544 6.07671 12.8815 6.09639 12.8999 6.116C12.9166 6.13375 12.9368 6.16247 12.9515 6.21636C12.9848 6.33784 13.0228 6.74712 12.9473 7.42262C12.874 8.07857 12.698 8.94479 12.341 9.9598C12.0424 10.8088 11.6601 11.5292 11.0684 12.4879C11.0558 12.5052 11.0462 12.5197 11.0418 12.5265L11.0404 12.5285C11.0292 12.5454 11.0242 12.5531 11.018 12.5618C11.0076 12.5764 11.0018 12.582 10.9983 12.585C10.996 12.587 10.9908 12.5912 10.9777 12.5959C10.9638 12.6009 10.9311 12.61 10.8706 12.61H4.56278L4.56373 5.58489C4.87126 5.41901 5.19881 5.20128 5.54112 4.84059C5.93883 4.42152 6.33789 3.8294 6.76254 2.94183C6.84974 2.75957 6.91745 2.55962 6.97574 2.37762C6.99264 2.32486 7.0087 2.27379 7.02438 2.22393L7.02439 2.22389C7.066 2.09158 7.10495 1.96776 7.14985 1.84312C7.2758 1.49352 7.40247 1.28101 7.56162 1.16952ZM9.45205 1.60729C9.13229 0.772086 8.70208 0.282772 8.17063 0.124374C7.64564 -0.0320981 7.20308 0.188912 6.98278 0.343248C6.55169 0.64525 6.33837 1.11908 6.20071 1.5012C6.14817 1.64705 6.10002 1.80016 6.05661 1.93824C6.0422 1.98405 6.02832 2.02821 6.01496 2.0699C5.95791 2.24804 5.90763 2.39115 5.85248 2.50643C5.45683 3.3334 5.1121 3.8271 4.80935 4.14611C4.51322 4.45815 4.23983 4.6219 3.9473 4.76821C3.71095 4.88641 3.55494 5.12906 3.55491 5.40159L3.55388 12.9125C3.55383 13.3026 3.87002 13.6188 4.26008 13.6188H10.8706C11.2097 13.6188 11.4663 13.5113 11.6519 13.3535C11.7387 13.2797 11.7988 13.2043 11.8387 13.1484C11.8556 13.1248 11.8704 13.1025 11.8786 13.09L11.8813 13.0859L11.8826 13.0839L11.8955 13.0685L11.9142 13.0382C12.5304 12.0414 12.9578 11.247 13.2927 10.2945C13.6745 9.20895 13.8679 8.26811 13.9499 7.5347C14.0297 6.82084 14.009 6.25845 13.9246 5.95014C13.805 5.51285 13.5104 5.26112 13.2134 5.13284C12.9385 5.01407 12.661 4.99859 12.5028 4.99836L9.49071 4.95631C9.92962 3.15791 9.64796 2.11902 9.45205 1.60729ZM0.000800636 5.46783C-0.0181914 5.0652 0.303128 4.72836 0.706212 4.72836H1.75264C2.14266 4.72836 2.45883 5.04454 2.45883 5.43456V12.9442C2.45883 13.3342 2.14266 13.6504 1.75264 13.6504H1.06044C0.68335 13.6504 0.372791 13.3541 0.355024 12.9775L0.000800636 5.46783Z" data-v-a8958c90="" fill="currentColor" fill-rule="evenodd">
</path>
</svg>
</div>
<span data-v-a8958c90="">
Python
</span>
</li>
</ul>
</div>
</div>
<div class="content-wrapper" data-v-a8958c90="" style="border-bottom:1px solid rgba(228, 230, 235, 0.5);">
<div class="content-main" data-v-a8958c90="">
<div class="title-row" data-v-a8958c90="">
<!---->
<!---->
<!---->
<a class="title" data-v-a8958c90="" href="/post/7025520956944678943" rel="" target="_blank" title="如何将Pandas数据转换为Excel文件">
如何将Pandas数据转换为Excel文件
</a>
</div>
<div class="abstract" data-v-a8958c90="">
<a data-v-a8958c90="" href="/post/7025520956944678943" rel="" target="_blank">
<div data-v-a8958c90="">
将数据导出到Excel文件通常是任何用户阅读和解释一组数据的最优先和最方便的方式。通过使用Pandas库，可以用Python代码将你的网络搜刮或其他收集的数据导出到Excel文件中，而且步骤非常简单。
</div>
</a>
</div>
<ul class="action-list jh-timeline-action-area" data-v-a8958c90="">
<li class="item view" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="view-icon" data-v-a8958c90="" fill="none" height="16" viewBox="0 0 16 16" width="16">
<path d="M7.90078 2.80078C4.49278 2.80078 1.74745 6.11672 0.800781 7.77469C1.74745 9.58339 4.49278 13.2008 7.90078 13.2008C11.3088 13.2008 14.0541 9.58339 15.0008 7.77469C14.0541 6.11672 11.3088 2.80078 7.90078 2.80078Z" data-v-a8958c90="" stroke="currentColor">
</path>
<circle cx="7.89922" cy="8.00078" data-v-a8958c90="" r="2.2" stroke="currentColor">
</circle>
</svg>
<span data-v-a8958c90="">
1642
</span>
</li>
<li class="item like" data-v-a8958c90="">
<div class="liked-wrap" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="liked-icon" data-v-a8958c90="" fill="none" height="14" viewBox="0 0 14 14" width="14">
<path clip-rule="evenodd" d="M7.56162 1.16952C7.66569 1.09661 7.78195 1.06124 7.88247 1.0912C7.97653 1.11923 8.23851 1.25916 8.50988 1.96799C8.64419 2.31881 8.9356 3.2424 8.42155 5.05431C8.29751 5.49152 8.61394 5.95303 9.09259 5.95971L12.492 6.00716L12.492 6.00721H12.4991C12.6049 6.00721 12.7228 6.01986 12.8134 6.05898C12.8544 6.07671 12.8815 6.09639 12.8999 6.116C12.9166 6.13375 12.9368 6.16247 12.9515 6.21636C12.9848 6.33784 13.0228 6.74712 12.9473 7.42262C12.874 8.07857 12.698 8.94479 12.341 9.9598C12.0424 10.8088 11.6601 11.5292 11.0684 12.4879C11.0558 12.5052 11.0462 12.5197 11.0418 12.5265L11.0404 12.5285C11.0292 12.5454 11.0242 12.5531 11.018 12.5618C11.0076 12.5764 11.0018 12.582 10.9983 12.585C10.996 12.587 10.9908 12.5912 10.9777 12.5959C10.9638 12.6009 10.9311 12.61 10.8706 12.61H4.56278L4.56373 5.58489C4.87126 5.41901 5.19881 5.20128 5.54112 4.84059C5.93883 4.42152 6.33789 3.8294 6.76254 2.94183C6.84974 2.75957 6.91745 2.55962 6.97574 2.37762C6.99264 2.32486 7.0087 2.27379 7.02438 2.22393L7.02439 2.22389C7.066 2.09158 7.10495 1.96776 7.14985 1.84312C7.2758 1.49352 7.40247 1.28101 7.56162 1.16952ZM9.45205 1.60729C9.13229 0.772086 8.70208 0.282772 8.17063 0.124374C7.64564 -0.0320981 7.20308 0.188912 6.98278 0.343248C6.55169 0.64525 6.33837 1.11908 6.20071 1.5012C6.14817 1.64705 6.10002 1.80016 6.05661 1.93824C6.0422 1.98405 6.02832 2.02821 6.01496 2.0699C5.95791 2.24804 5.90763 2.39115 5.85248 2.50643C5.45683 3.3334 5.1121 3.8271 4.80935 4.14611C4.51322 4.45815 4.23983 4.6219 3.9473 4.76821C3.71095 4.88641 3.55494 5.12906 3.55491 5.40159L3.55388 12.9125C3.55383 13.3026 3.87002 13.6188 4.26008 13.6188H10.8706C11.2097 13.6188 11.4663 13.5113 11.6519 13.3535C11.7387 13.2797 11.7988 13.2043 11.8387 13.1484C11.8556 13.1248 11.8704 13.1025 11.8786 13.09L11.8813 13.0859L11.8826 13.0839L11.8955 13.0685L11.9142 13.0382C12.5304 12.0414 12.9578 11.247 13.2927 10.2945C13.6745 9.20895 13.8679 8.26811 13.9499 7.5347C14.0297 6.82084 14.009 6.25845 13.9246 5.95014C13.805 5.51285 13.5104 5.26112 13.2134 5.13284C12.9385 5.01407 12.661 4.99859 12.5028 4.99836L9.49071 4.95631C9.92962 3.15791 9.64796 2.11902 9.45205 1.60729ZM0.000800636 5.46783C-0.0181914 5.0652 0.303128 4.72836 0.706212 4.72836H1.75264C2.14266 4.72836 2.45883 5.04454 2.45883 5.43456V12.9442C2.45883 13.3342 2.14266 13.6504 1.75264 13.6504H1.06044C0.68335 13.6504 0.372791 13.3541 0.355024 12.9775L0.000800636 5.46783Z" data-v-a8958c90="" fill="currentColor" fill-rule="evenodd">
</path>
</svg>
</div>
<span data-v-a8958c90="">
</span>
</li>
</ul>
</div>
</div>
<div class="content-wrapper" data-v-a8958c90="" style="border-bottom:1px solid rgba(228, 230, 235, 0.5);">
<div class="content-main" data-v-a8958c90="">
<div class="title-row" data-v-a8958c90="">
<!---->
<!---->
<!---->
<a class="title" data-v-a8958c90="" href="/post/7112654335657377829" rel="" target="_blank" title="如何用Tibble和dplyr在R中向数据框架添加一列">
如何用Tibble和dplyr在R中向数据框架添加一列
</a>
</div>
<div class="abstract" data-v-a8958c90="">
<a data-v-a8958c90="" href="/post/7112654335657377829" rel="" target="_blank">
<div data-v-a8958c90="">
The postHow to Add a Column to a Dataframe in R with tibble & dplyrappeared first onErik Marsja. 在这个
</div>
</a>
</div>
<ul class="action-list jh-timeline-action-area" data-v-a8958c90="">
<li class="item view" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="view-icon" data-v-a8958c90="" fill="none" height="16" viewBox="0 0 16 16" width="16">
<path d="M7.90078 2.80078C4.49278 2.80078 1.74745 6.11672 0.800781 7.77469C1.74745 9.58339 4.49278 13.2008 7.90078 13.2008C11.3088 13.2008 14.0541 9.58339 15.0008 7.77469C14.0541 6.11672 11.3088 2.80078 7.90078 2.80078Z" data-v-a8958c90="" stroke="currentColor">
</path>
<circle cx="7.89922" cy="8.00078" data-v-a8958c90="" r="2.2" stroke="currentColor">
</circle>
</svg>
<span data-v-a8958c90="">
1392
</span>
</li>
<li class="item like" data-v-a8958c90="">
<div class="liked-wrap" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="liked-icon" data-v-a8958c90="" fill="none" height="14" viewBox="0 0 14 14" width="14">
<path clip-rule="evenodd" d="M7.56162 1.16952C7.66569 1.09661 7.78195 1.06124 7.88247 1.0912C7.97653 1.11923 8.23851 1.25916 8.50988 1.96799C8.64419 2.31881 8.9356 3.2424 8.42155 5.05431C8.29751 5.49152 8.61394 5.95303 9.09259 5.95971L12.492 6.00716L12.492 6.00721H12.4991C12.6049 6.00721 12.7228 6.01986 12.8134 6.05898C12.8544 6.07671 12.8815 6.09639 12.8999 6.116C12.9166 6.13375 12.9368 6.16247 12.9515 6.21636C12.9848 6.33784 13.0228 6.74712 12.9473 7.42262C12.874 8.07857 12.698 8.94479 12.341 9.9598C12.0424 10.8088 11.6601 11.5292 11.0684 12.4879C11.0558 12.5052 11.0462 12.5197 11.0418 12.5265L11.0404 12.5285C11.0292 12.5454 11.0242 12.5531 11.018 12.5618C11.0076 12.5764 11.0018 12.582 10.9983 12.585C10.996 12.587 10.9908 12.5912 10.9777 12.5959C10.9638 12.6009 10.9311 12.61 10.8706 12.61H4.56278L4.56373 5.58489C4.87126 5.41901 5.19881 5.20128 5.54112 4.84059C5.93883 4.42152 6.33789 3.8294 6.76254 2.94183C6.84974 2.75957 6.91745 2.55962 6.97574 2.37762C6.99264 2.32486 7.0087 2.27379 7.02438 2.22393L7.02439 2.22389C7.066 2.09158 7.10495 1.96776 7.14985 1.84312C7.2758 1.49352 7.40247 1.28101 7.56162 1.16952ZM9.45205 1.60729C9.13229 0.772086 8.70208 0.282772 8.17063 0.124374C7.64564 -0.0320981 7.20308 0.188912 6.98278 0.343248C6.55169 0.64525 6.33837 1.11908 6.20071 1.5012C6.14817 1.64705 6.10002 1.80016 6.05661 1.93824C6.0422 1.98405 6.02832 2.02821 6.01496 2.0699C5.95791 2.24804 5.90763 2.39115 5.85248 2.50643C5.45683 3.3334 5.1121 3.8271 4.80935 4.14611C4.51322 4.45815 4.23983 4.6219 3.9473 4.76821C3.71095 4.88641 3.55494 5.12906 3.55491 5.40159L3.55388 12.9125C3.55383 13.3026 3.87002 13.6188 4.26008 13.6188H10.8706C11.2097 13.6188 11.4663 13.5113 11.6519 13.3535C11.7387 13.2797 11.7988 13.2043 11.8387 13.1484C11.8556 13.1248 11.8704 13.1025 11.8786 13.09L11.8813 13.0859L11.8826 13.0839L11.8955 13.0685L11.9142 13.0382C12.5304 12.0414 12.9578 11.247 13.2927 10.2945C13.6745 9.20895 13.8679 8.26811 13.9499 7.5347C14.0297 6.82084 14.009 6.25845 13.9246 5.95014C13.805 5.51285 13.5104 5.26112 13.2134 5.13284C12.9385 5.01407 12.661 4.99859 12.5028 4.99836L9.49071 4.95631C9.92962 3.15791 9.64796 2.11902 9.45205 1.60729ZM0.000800636 5.46783C-0.0181914 5.0652 0.303128 4.72836 0.706212 4.72836H1.75264C2.14266 4.72836 2.45883 5.04454 2.45883 5.43456V12.9442C2.45883 13.3342 2.14266 13.6504 1.75264 13.6504H1.06044C0.68335 13.6504 0.372791 13.3541 0.355024 12.9775L0.000800636 5.46783Z" data-v-a8958c90="" fill="currentColor" fill-rule="evenodd">
</path>
</svg>
</div>
<span data-v-a8958c90="">
不思量自难忘
Python
</span>
</li>
</ul>
</div>
</div>
<div class="content-wrapper" data-v-a8958c90="" style="border-bottom:0;">
<div class="content-main" data-v-a8958c90="">
<div class="title-row" data-v-a8958c90="">
<!---->
<!---->
<!---->
<a class="title" data-v-a8958c90="" href="/post/6985188896665518110" rel="" target="_blank" title="pandas系列之缺失值的处理">
pandas系列之缺失值的处理
</a>
</div>
<div class="abstract" data-v-a8958c90="">
<a data-v-a8958c90="" href="/post/6985188896665518110" rel="" target="_blank">
<div data-v-a8958c90="">
这是pandas系列第七篇，主要介绍了针对数据中缺失值的相关处理，包括缺失值的查看、判断、删除和填充等内容。
</div>
</a>
</div>
<ul class="action-list jh-timeline-action-area" data-v-a8958c90="">
<li class="item view" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="view-icon" data-v-a8958c90="" fill="none" height="16" viewBox="0 0 16 16" width="16">
<path d="M7.90078 2.80078C4.49278 2.80078 1.74745 6.11672 0.800781 7.77469C1.74745 9.58339 4.49278 13.2008 7.90078 13.2008C11.3088 13.2008 14.0541 9.58339 15.0008 7.77469C14.0541 6.11672 11.3088 2.80078 7.90078 2.80078Z" data-v-a8958c90="" stroke="currentColor">
</path>
<circle cx="7.89922" cy="8.00078" data-v-a8958c90="" r="2.2" stroke="currentColor">
</circle>
</svg>
<span data-v-a8958c90="">
1422
</span>
</li>
<li class="item like" data-v-a8958c90="">
<div class="liked-wrap" data-v-a8958c90="">
<svg xmlns="http://www.w3.org/2000/svg" class="liked-icon" data-v-a8958c90="" fill="none" height="14" viewBox="0 0 14 14" width="14">
<path clip-rule="evenodd" d="M7.56162 1.16952C7.66569 1.09661 7.78195 1.06124 7.88247 1.0912C7.97653 1.11923 8.23851 1.25916 8.50988 1.96799C8.64419 2.31881 8.9356 3.2424 8.42155 5.05431C8.29751 5.49152 8.61394 5.95303 9.09259 5.95971L12.492 6.00716L12.492 6.00721H12.4991C12.6049 6.00721 12.7228 6.01986 12.8134 6.05898C12.8544 6.07671 12.8815 6.09639 12.8999 6.116C12.9166 6.13375 12.9368 6.16247 12.9515 6.21636C12.9848 6.33784 13.0228 6.74712 12.9473 7.42262C12.874 8.07857 12.698 8.94479 12.341 9.9598C12.0424 10.8088 11.6601 11.5292 11.0684 12.4879C11.0558 12.5052 11.0462 12.5197 11.0418 12.5265L11.0404 12.5285C11.0292 12.5454 11.0242 12.5531 11.018 12.5618C11.0076 12.5764 11.0018 12.582 10.9983 12.585C10.996 12.587 10.9908 12.5912 10.9777 12.5959C10.9638 12.6009 10.9311 12.61 10.8706 12.61H4.56278L4.56373 5.58489C4.87126 5.41901 5.19881 5.20128 5.54112 4.84059C5.93883 4.42152 6.33789 3.8294 6.76254 2.94183C6.84974 2.75957 6.91745 2.55962 6.97574 2.37762C6.99264 2.32486 7.0087 2.27379 7.02438 2.22393L7.02439 2.22389C7.066 2.09158 7.10495 1.96776 7.14985 1.84312C7.2758 1.49352 7.40247 1.28101 7.56162 1.16952ZM9.45205 1.60729C9.13229 0.772086 8.70208 0.282772 8.17063 0.124374C7.64564 -0.0320981 7.20308 0.188912 6.98278 0.343248C6.55169 0.64525 6.33837 1.11908 6.20071 1.5012C6.14817 1.64705 6.10002 1.80016 6.05661 1.93824C6.0422 1.98405 6.02832 2.02821 6.01496 2.0699C5.95791 2.24804 5.90763 2.39115 5.85248 2.50643C5.45683 3.3334 5.1121 3.8271 4.80935 4.14611C4.51322 4.45815 4.23983 4.6219 3.9473 4.76821C3.71095 4.88641 3.55494 5.12906 3.55491 5.40159L3.55388 12.9125C3.55383 13.3026 3.87002 13.6188 4.26008 13.6188H10.8706C11.2097 13.6188 11.4663 13.5113 11.6519 13.3535C11.7387 13.2797 11.7988 13.2043 11.8387 13.1484C11.8556 13.1248 11.8704 13.1025 11.8786 13.09L11.8813 13.0859L11.8826 13.0839L11.8955 13.0685L11.9142 13.0382C12.5304 12.0414 12.9578 11.247 13.2927 10.2945C13.6745 9.20895 13.8679 8.26811 13.9499 7.5347C14.0297 6.82084 14.009 6.25845 13.9246 5.95014C13.805 5.51285 13.5104 5.26112 13.2134 5.13284C12.9385 5.01407 12.661 4.99859 12.5028 4.99836L9.49071 4.95631C9.92962 3.15791 9.64796 2.11902 9.45205 1.60729ZM0.000800636 5.46783C-0.0181914 5.0652 0.303128 4.72836 0.706212 4.72836H1.75264C2.14266 4.72836 2.45883 5.04454 2.45883 5.43456V12.9442C2.45883 13.3342 2.14266 13.6504 1.75264 13.6504H1.06044C0.68335 13.6504 0.372791 13.3541 0.355024 12.9775L0.000800636 5.46783Z" data-v-a8958c90="" fill="currentColor" fill-rule="evenodd">
</path>
</svg>
</div>
<span data-v-a8958c90="">
</span>
</li>
</ul>
</div>
</div>
<div class="sep10"></div>
</div>
</div>
</div>
<div class="topic_buttons">
<div class="fr gray f11"
style="line-height: 12px; padding-top: 3px; text-shadow: 0px 1px 0px #fff;">
</div>
</div>
</div>
<div class="sep5"></div>
<div class="box">
<div class="cell">
<span class="gray">推荐文章</span>
</div>
<div class="cell">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tbody>
<tr>
<td width="32" valign="top" align="center">
<a href="http://code.python88.com/u/NYDT1CRh8o" ><img
src="http://img.python88.com/avatars/avatars/user-default.jpg?imageView2/2/w/100&imageView2/2/w/100"
class="avatar" style="max-width: 32px; max-height: 32px;"
border="0" align="default"></a>
</td>
<td width="10" valign="top"></td>
<td width="auto" valign="top" align="left">
<span class="item_hot_topic_title">
<a href="http://code.python88.com/u/NYDT1CRh8o">无聊的杨桃</a>
·
<a target="_blank" href="http://code.python88.com/l/Jq8SSfP1yU">Excel VBA技术问询：从单个单元格提取多值分配给多个变量</a>
</span>
<div class="sep5"></div>
<span class="fade">2 月前</span>
<small class="gray">
</small>
</td>
</tr>
</tbody>
</table>
</div>
<div class="cell">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tbody>
<tr>
<td width="32" valign="top" align="center">
<a href="http://code.python88.com/u/rOFS53vcrP" ><img
src="http://img.python88.com/avatars/avatars/user-default.jpg?imageView2/2/w/100&imageView2/2/w/100"
class="avatar" style="max-width: 32px; max-height: 32px;"
border="0" align="default"></a>
</td>
<td width="10" valign="top"></td>
<td width="auto" valign="top" align="left">
<span class="item_hot_topic_title">
<a href="http://code.python88.com/u/rOFS53vcrP">刚分手的皮蛋</a>
·
<a target="_blank" href="http://code.python88.com/l/sQ1n4Zsrwt">咨询：无需VBA实现Excel单元格内容自动匿名化的方法</a>
</span>
<div class="sep5"></div>
<span class="fade">2 月前</span>
<small class="gray">
</small>
</td>
</tr>
</tbody>
</table>
</div>
<div class="cell">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tbody>
<tr>
<td width="32" valign="top" align="center">
<a href="http://code.python88.com/u/VxnjGIXUOE" ><img
src="http://img.python88.com/avatars/avatars/user-default.jpg?imageView2/2/w/100&imageView2/2/w/100"
class="avatar" style="max-width: 32px; max-height: 32px;"
border="0" align="default"></a>
</td>
<td width="10" valign="top"></td>
<td width="auto" valign="top" align="left">
<span class="item_hot_topic_title">
<a href="http://code.python88.com/u/VxnjGIXUOE">坚韧的伤痕</a>
·
<a target="_blank" href="http://code.python88.com/l/7IcbHu9tTC">利用VBA代码解决Excel下拉菜单跳过空单元格的问题_vba下拉框如何去除空白单元格</a>
</span>
<div class="sep5"></div>
<span class="fade">2 月前</span>
<small class="gray">
</small>
</td>
</tr>
</tbody>
</table>
</div>
<div class="cell">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tbody>
<tr>
<td width="32" valign="top" align="center">
<a href="http://code.python88.com/u/QLWwa60MsB" ><img
src="http://img.python88.com/avatars/avatars/user-default.jpg?imageView2/2/w/100&imageView2/2/w/100"
class="avatar" style="max-width: 32px; max-height: 32px;"
border="0" align="default"></a>
</td>
<td width="10" valign="top"></td>
<td width="auto" valign="top" align="left">
<span class="item_hot_topic_title">
<a href="http://code.python88.com/u/QLWwa60MsB">文武双全的自行车</a>
·
<a target="_blank" href="http://code.python88.com/l/aDyX4Uj57N">ReportLab表格单元格条件着色求助：负数单元格设为红色遇阻</a>
</span>
<div class="sep5"></div>
<span class="fade">1 月前</span>
<small class="gray">
</small>
</td>
</tr>
</tbody>
</table>
</div>
<div class="cell">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tbody>
<tr>
<td width="32" valign="top" align="center">
<a href="http://code.python88.com/u/hPXl1chU8U" ><img
src="http://img.python88.com/avatars/avatars/user-default.jpg?imageView2/2/w/100&imageView2/2/w/100"
class="avatar" style="max-width: 32px; max-height: 32px;"
border="0" align="default"></a>
</td>
<td width="10" valign="top"></td>
<td width="auto" valign="top" align="left">
<span class="item_hot_topic_title">
<a href="http://code.python88.com/u/hPXl1chU8U">喝醉的骆驼</a>
·
<a target="_blank" href="http://code.python88.com/l/KVy1U2JHNe">K4A — Python documentation</a>
</span>
<div class="sep5"></div>
<span class="fade">1 年前</span>
<small class="gray">
</small>
</td>
</tr>
</tbody>
</table>
</div>
<div class="cell">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tbody>
<tr>
<td width="32" valign="top" align="center">
<a href="http://code.python88.com/u/VRGBwuyJIO" ><img
src="http://img.python88.com/avatars/avatars/user-default.jpg?imageView2/2/w/100&imageView2/2/w/100"
class="avatar" style="max-width: 32px; max-height: 32px;"
border="0" align="default"></a>
</td>
<td width="10" valign="top"></td>
<td width="auto" valign="top" align="left">
<span class="item_hot_topic_title">
<a href="http://code.python88.com/u/VRGBwuyJIO">刚分手的肉夹馍</a>
·
<a target="_blank" href="http://code.python88.com/l/zpOUpRCLW6">【失信曝光台】柴桑法院发布2024年第一批失信被执行人名单，你认得几个？
,信用中国（江西柴桑）,
联合惩戒
,
联合奖惩动态</a>
</span>
<div class="sep5"></div>
<span class="fade">1 年前</span>
<small class="gray">
</small>
</td>
</tr>
</tbody>
</table>
</div>
<div class="cell">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tbody>
<tr>
<td width="32" valign="top" align="center">
<a href="http://code.python88.com/u/GfTAEg2OKI" ><img
src="http://img.python88.com/avatars/avatars/user-default.jpg?imageView2/2/w/100&imageView2/2/w/100"
class="avatar" style="max-width: 32px; max-height: 32px;"
border="0" align="default"></a>
</td>
<td width="10" valign="top"></td>
<td width="auto" valign="top" align="left">
<span class="item_hot_topic_title">
<a href="http://code.python88.com/u/GfTAEg2OKI">至今单身的伏特加</a>
·
<a target="_blank" href="http://code.python88.com/l/5pHRjfQIZc">js正则去掉括号_js正则去掉大括号_js正则去掉方括号 - 腾讯云开发者社区 - 腾讯云</a>
</span>
<div class="sep5"></div>
<span class="fade">2 年前</span>
<small class="gray">
</small>
</td>
</tr>
</tbody>
</table>
</div>
<div class="cell">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tbody>
<tr>
<td width="32" valign="top" align="center">
<a href="http://code.python88.com/u/UAty4zZhtm" ><img
src="http://img.python88.com/avatars/avatars/user-default.jpg?imageView2/2/w/100&imageView2/2/w/100"
class="avatar" style="max-width: 32px; max-height: 32px;"
border="0" align="default"></a>
</td>
<td width="10" valign="top"></td>
<td width="auto" valign="top" align="left">
<span class="item_hot_topic_title">
<a href="http://code.python88.com/u/UAty4zZhtm">魁梧的葫芦</a>
·
<a target="_blank" href="http://code.python88.com/l/XY97CyfrNU">pro-oracle: Oracle Database 19c -- ORA-29024: Certificate validation failure</a>
</span>
<div class="sep5"></div>
<span class="fade">2 年前</span>
<small class="gray">
</small>
</td>
</tr>
</tbody>
</table>
</div>
<div class="cell">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tbody>
<tr>
<td width="32" valign="top" align="center">
<a href="http://code.python88.com/u/1raeYQYf2F" ><img
src="http://img.python88.com/avatars/avatars/user-default.jpg?imageView2/2/w/100&imageView2/2/w/100"
class="avatar" style="max-width: 32px; max-height: 32px;"
border="0" align="default"></a>
</td>
<td width="10" valign="top"></td>
<td width="auto" valign="top" align="left">
<span class="item_hot_topic_title">
<a href="http://code.python88.com/u/1raeYQYf2F">高大的烤红薯</a>
·
<a target="_blank" href="http://code.python88.com/l/TrlmFcYYnE">上海生物样本库工程技术研究中心</a>
</span>
<div class="sep5"></div>
<span class="fade">2 年前</span>
<small class="gray">
</small>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="sep5"></div>
<div class="box">
<div class="cell">
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 普通广告（正在使用） -->
<ins class="adsbygoogle"
style="display:block"
data-ad-client="ca-pub-1837452791782084"
data-ad-slot="6787195013"
data-ad-format="auto"
data-full-width-responsive="true"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div>
</div>
<div class="sep5"></div>
</div>
</div>
<div class="c"></div>
<div class="sep20"></div>
</div>
<div id="Bottom">
<div class="content footer">
<div class="inner">
<div class="sep10"></div>
<div class="fr">
</div>
<strong>
<a href="http://www.jintiankansha.me/" class="dark" target="_blank">今天看啥</a>
<span class="snow">·</span>
<a href="http://www.python88.com/" class="dark" target="_blank">Py中国</a>
<span class="snow">·</span>
<a href="http://www.codingpro.cn/" class="dark" target="_blank">codingpro</a>
<span class="snow">·</span>
<a href="http://baike.linkmax.top" class="dark" target="_blank">小百科</a>
<span class="snow">·</span>
<a href="http://www.linkmax.top" class="dark" target="_blank">link之家</a>
<span class="snow">·</span>
<a href="http://www.wolongai.cn" class="dark" target="_blank">卧龙AI搜索</a>
</strong>
<div class="sep10"></div>
删除内容请联系邮箱 2879853325@qq.com
<div class="sep10"></div>
Code - 代码工具平台
<div class="sep10"></div>
<span class="f12 gray">© 2024 ~
<a href="http://beian.miit.gov.cn/" target="_blank"
rel="nofollow">沪ICP备11025650号</a></span>
<div class="sep10"></div>
</div>
</div>
</div>
<script type="text/javascript" src="https://img.100weidu.com/cdn/highlight.js/9.2.0/highlight.min.js"></script>
<script type="text/javascript" src="https://img.100weidu.com/cdn/jquery/1.11.0/jquery.min.js"></script>
<script type="text/javascript" src="https://img.100weidu.com/cdn/jqueryui/1.9.2/jquery-ui.min.js"></script>
<script type="text/javascript" src="/static/js/site/base/common.js?v=97646d06e4a04b2bf43b7b467cfd321e"></script>
<script type="text/javascript" src="/static/js/site/base/v2ex.js?v=d41d8cd98f00b204e9800998ecf8427e"></script>
<script type="text/javascript" src="/static/js/site/base/base.js?v=4734e41dc8139093c113d6a48489a0f4"></script>
<script>
var _hmt = _hmt || [];
(function () {
var hm = document.createElement("script");
hm.src = "https://hm.baidu.com/hm.js?94b9935d8881b2e37490d19acfb0f6e4";
var s = document.getElementsByTagName("script")[0];
s.parentNode.insertBefore(hm, s);
})();
</script>
<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-P95KGR6D7D"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'G-P95KGR6D7D');
</script>
<script>
(function () {
var bp = document.createElement('script');
var curProtocol = window.location.protocol.split(':')[0];
if (curProtocol === 'https') {
bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';
} else {
bp.src = 'http://push.zhanzhang.baidu.com/push.js';
}
var s = document.getElementsByTagName("script")[0];
s.parentNode.insertBefore(bp, s);
})();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/cm.js" async="async" defer="defer">
</script>
<script type="text/javascript" src="/static/js/site/post/post_common.js?v=8d0f2fe55813416f744bc961e1768685"></script>
</body>
</html> 
