tmp

#!/usr/bin/env python
# coding: utf-8

# In[1]:


import pandas as pd
import numpy as np


# In[2]:


tmp_code = 603288
index_name_file = "./key_index/index_{0:06d}.csv".format(tmp_code)


# In[76]:


index_tmp_df = pd.read_csv(index_name_file,header=None, index_col=0, encoding="gb2312").T


# In[77]:


index_tmp_df = index_tmp_df.dropna()


# In[78]:


index_tmp_df.index


# In[80]:


index_tmp_df.head()


# In[81]:


# print(index_name)
index_tmp_df["报告日期"]


# In[ ]:





# In[82]:


# index_tmp_df.set_index(["报告日期"])
# index_tmp_df.index
index_tmp_df['date'] = pd.to_datetime(index_tmp_df["报告日期"])


# In[85]:


index_tmp_df = index_tmp_df.set_index("date")


# In[86]:


index_tmp_df.columns


# In[87]:


index_tmp_df.index


# In[90]:


index_tmp_df.index.to_period('Q')


# In[98]:


index_tmp_df.loc["2018-12-31"]


# In[100]:


index_tmp_df["报告日期"].apply()


# In[103]:


annual_df = index_tmp_df.loc[index_tmp_df['报告日期'].apply(lambda x: str(x).endswith("12-31"))]


# In[104]:


annual_df.head()


# In[ ]:





# In[24]:


index_tmp_df


# In[ ]: