擅长:python、mysql、java
<p>细绳切片。此语法最多保留6个字符:</p>
<pre><code>>>> s = '1234567890'
>>> s = s[:6]
>>> s
'123456'
>>> s = '1234'
>>> s = s[:6]
>>> s
'1234'
</code></pre>
<p>具体来说,如果使用<code>pandas</code>:</p>
<pre><code>>>> import pandas as pd
>>> df = pd.read_csv('data.csv')
>>> df
ComputerName DaysCheckIn
0 CTE14001 160
1 CLB209LT11S 144
2 WPK-REG 135
3 ATB190S01 91
>>> df['ComputerName']
0 CTE14001
1 CLB209LT11S
2 WPK-REG
3 ATB190S01
>>> # Take strings in named column and truncate to no more than 6 characters
>>> df['ComputerName'] = df['ComputerName'].str[:6]
>>> df
ComputerName DaysCheckIn
0 CTE140 160
1 CLB209 144
2 WPK-RE 135
3 ATB190 91
</code></pre>