我有一个数据表,我希望在python中以线图的形式进行绘制,但我无法理解如何将其塑造成我想要的图形
import pandas as pd
data = {'Cost_Range_': ['0%-10% ', '10%-20% ', '20%-30% ', '30%-40% ', '40%-50% ', '50%-60% ', '60%-70% ', '70%-80% ', '80%-90% ', '90%-100% '], 'Actual_Cost_7': [862524.95, 2103586.97, 4787800.34, 7566317.48, 9234256.79, 8089529.83, 8404393.25, 7914513.2, 7295344.15, 28349329.54], 'Actual_Cost_8': [774796.59, 1926257.27, 4500831.22, 6996465.31, 8649839.07, 7637765.74, 7894598.06, 7507044.41, 6992852.64, 26793378.2], 'Actual_Cost_9': [735822.59, 1950636.11, 4630232.69, 7258691.84, 8876958.69, 7871133.78, 8190628.12, 7780306.34, 7112415.57, 27498755.9], 'Actual_Cost_10': [767162.99, 2005088.29, 4724279.94, 7518358.25, 9308307.16, 8099628.47, 8566112.41, 8012750.97, 7596157.21, 28593451.29], 'Actual_Cost_11': [723476.43, 2011078.37, 4642348.79, 7258459.29, 9032494.08, 7969659.06, 8334203.4, 7882871.23, 7327570.81, 27901242.65], 'Actual_Cost_12': [760538.83, 1940075.69, 4371315.1, 6953409.04, 8695870.37, 7647885.77, 7871087.21, 7517534.52, 6971178.15, 26562179.63]}
df = pd.DataFrame(data)
Cost_Range_ Actual_Cost_7 Actual_Cost_8 Actual_Cost_9 Actual_Cost_10 Actual_Cost_11 Actual_Cost_12
0 0%-10% 862524.95 774796.59 735822.59 767162.99 723476.43 760538.83
1 10%-20% 2103586.97 1926257.27 1950636.11 2005088.29 2011078.37 1940075.69
2 20%-30% 4787800.34 4500831.22 4630232.69 4724279.94 4642348.79 4371315.10
3 30%-40% 7566317.48 6996465.31 7258691.84 7518358.25 7258459.29 6953409.04
4 40%-50% 9234256.79 8649839.07 8876958.69 9308307.16 9032494.08 8695870.37
5 50%-60% 8089529.83 7637765.74 7871133.78 8099628.47 7969659.06 7647885.77
6 60%-70% 8404393.25 7894598.06 8190628.12 8566112.41 8334203.40 7871087.21
7 70%-80% 7914513.20 7507044.41 7780306.34 8012750.97 7882871.23 7517534.52
8 80%-90% 7295344.15 6992852.64 7112415.57 7596157.21 7327570.81 6971178.15
9 90%-100% 28349329.54 26793378.20 27498755.90 28593451.29 27901242.65 26562179.63
如有任何建议,将不胜感激
pd.melt()
开始,为构建详细的结构相关问题 更多 >
编程相关推荐