python-3.x - 使用python制作数据趋势
问题描述
我想使用 python 为数据框制作数据趋势,例如我在 csv 中的原始数据低于格式
Date TCH_Nom TCH_Denom SD_Nom SD_Denom
1/08/2018 42 58 4 21
2/08/2018 67 100 12 120
3/08/2018 23 451 9 34
输出应该是
KPI 1/08/2018 2/08/2018 3/08/2018
TCH_Nom 42 67 23
TCH_Denom 58 100 451
SD_Nom 4 12 9
SD_Denom 21 120 34
解决方案
from io import StringIO
import pandas as pd
txt = '''Date TCH_Nom TCH_Denom SD_Nom SD_Denom
1/08/2018 42 58 4 21
2/08/2018 67 100 12 120
3/08/2018 23 451 9 34'''
df = pd.read_table(StringIO(txt),sep = '\s+')
正如评论中指出的:
df.set_index('Date',inplace = True) # set index to Date column
df.T
这给出了这个结果:
Date 1/08/2018 2/08/2018 3/08/2018
TCH_Nom 42 67 23
TCH_Denom 58 100 451
SD_Nom 4 12 9
SD_Denom 21 120 34
推荐阅读
- rxjs - how to unsubscribe a RXJS subscription inside the subscribe method?
- boost - How to strip version folder from Windows Boost build?
- discord.py - A client event prevents my commands from working
- javascript - How to avoid from expose IP address directly in JS?
- angular - how I can get Validators.minLength of form input and set it in html dynamicly?
- linux - Linux - Diff number of lines in 2 set of files
- django - Django- How do I select particular columns from a model?
- logstash - How to get the content of only one field in logstash
- python - Pandas - fill missing date value of dataframe and copying column values except for one
- javascript - html and javascript on a simiple table