title: Quarter Data to month data
body: <p>I have a Dataframe with a column Date. The date is written as 2002Q1, 2002Q2,....</p>
  
  <p>I like to have for every quarter three lines instead of one and rename the date as 20020101, 20020201 and 20020301 as an example for the first quarter. </p>
  
  <p>Do you have any idea. Thank you</p>
  
  <p>My Code</p>
  
  <pre><code>    list=pd.read_csv(r"C:\Usersxyx.csv", delimiter = ',', usecols=["date", "ID", 'Value'])
  list['year'] = [str(i)[:4] for i in list["date"]]
  list ['month']= [str(i)[5:6] for i in list["date"]]
  blist= pd.DataFrame(np.repeat(list.values, 3, axis=0))
  blist.columns = list.columns
  </code></pre>
  
  <p>My idea was to copy the row three times. So that I have a line for every month. And now I have no clue how i can change the Date from 2001Q1 in 20010101 20010201 and so. </p>