擅长:python、mysql、java
<p>在pandas中定制函数非常容易。
也许你可以试试这些:</p>
<pre><code># import
import pandas as pd
# reading file
df = pd.read_csv("PATH_TO_CSV_FILE")
def func_CPU(x):
""" function for CPU related columns"""
if x[-1] == "m":
return float(x[:-1])/1000
else: return x
def func_Memory(x):
""" function for Memory related columns"""
if x[-2:] == "Gi":
return float(x[:-2]) * 1024 *0.00104858
elif x[-2:] == "Mi":
return float(x[:-2]) * 0.00104858
else: return x
df["Used_CPU"] = df["Used_CPU"].apply(func_CPU)
df["Used_Memory"] = df["Used_Memory"].apply(func_Memory)
df["Hard_CPU"] = df["Hard_CPU"].apply(func_CPU)
df["Hard_Memory"] = df["Hard_Memory"].apply(func_Memory)
print(df)
</code></pre>