python生成化学结构_Pandas生成结构化报告,结构式

import numpy as np

import pandas as pd

import sys

import matplotlib.pyplot as plt

plt.close('all')

# 任务1：绘制按月份的销售额

dataPath = r'D:\\\\data.csv'

df =pd.read_csv(dataPath)

df.columns = ['num','time','delt','from','fromDes','ip','date','name',

'p6688','p4011','p1012','p1013','p1025',

'p1026','p4666','p4777','p4000','p4324',

'pDuo','image','note','Amount']

df=df[~df['date'].str.contains('空')] #删除某列包含特殊字符的行

#清理一下空数据

df['date'] = pd.to_datetime(df['date']) # 将数据类型转换为日期类型

df = df.set_index('date') # 将date设置为index

s = pd.Series(df['Amount'], index&