擅长:python、mysql、java
<p>如果列值始终是文件名/文件路径,请使用maxsplit参数<code>1</code>从<code>.</code>的右侧将其拆分,并获取拆分后的第一个值</p>
<pre class="lang-py prettyprint-override"><code>>>> df['relfilepath'].str.rsplit('.', n=1).str[0]
0 20210322636
12 factuur-f23622
14 ingram micro
19 upfront.nl domein - Copy
21 upfront.nl domein
Name: relfilepath, dtype: object
</code></pre>