title: Syncing another company's financial year to another company using EDGAR database
body: <p>I'm working on a school project that was built by a previous group, and one of my tasks is to synchronize the fiscal year's start date according to the start date of the company of focus.
  This is the code used to grab the json from EDGAR using their API.</p>
  <pre><code>d = requests.get(f&quot;https://data.sec.gov/api/xbrl/companyconcept/CIK{cik}/us-gaap/{kpi}.json&quot;,
                               headers=self.HEADER).json()
  </code></pre>
  <p>Which is then converted into a dataframe using pandas and then printed out</p>
  <pre><code>df = pd.DataFrame.from_dict(d)
  print(df.to_string())
  </code></pre>
  <p>I grab financial year data of a company using their CKI, for a certain KPI, in this case its AccountsPayableCurrent, but when I print out the data I don't see columns that relate to a start date, only end dates and other columns. Sample output below:</p>
  <blockquote>
  <p>cik taxonomy                     tag                      label                                                                                                                                                                                                                                                                                                                                           description    entityName                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     units
  USD  866787  us-gaap  AccountsPayableCurrent  Accounts Payable, Current  Carrying value as of the balance sheet date of liabilities incurred (and for which invoices have typically been received) and payable to vendors for goods and services received that are used in an entity's business. Used to reflect the current portion of the liabilities (due within one year or within the normal operating cycle if longer).  AUTOZONE INC  [{'end': '2009-08-29', 'val': 2118746000, 'accn': '0000950123-09-071593', 'fy': 2010, 'fp': 'Q1', 'form': '10-Q', 'filed': '2009-12-17'}, {'end': '2009-08-29', 'val': 2118746000, 'accn': '0000950123-10-025907', 'fy': 2010, 'fp': 'Q2', 'form': '10-Q', 'filed': '2010-03-18'}, {'end': '2009-08-29', 'val': 2118746000, 'accn': '0000950123-10-058650', 'fy': 2010, 'fp': 'Q3', 'form': '10-Q', 'filed': '2010-06-16'}, {'end': '2009-08-29', 'val': 2118746000, 'accn': '0000950123-10-095687', 'fy': 2010, 'fp': 'FY', 'form': '10-K', 'filed': '2010-10-25', 'frame': 'CY2009Q3I'}, {'end': '2009-11-21', 'val': 2187347000, 'accn': '0000950123-09-071593', 'fy': 2010, 'fp': 'Q1', 'form': '10-Q', 'filed': '2009-12-17', 'frame': 'CY2009Q4I'}, {'end': '2010-02-13', 'val': 2144995000, 'accn': '0000950123-10-025907', 'fy': 2010, 'fp': 'Q2', 'form': '10-Q', 'filed': '2010-03-18'}, {'end': '2010-05-08', 'val': 2235766000, 'accn': '0000950123-10-058650', 'fy': 2010, 'fp': 'Q3', 'form': '10-Q', 'filed': '2010-06-16', 'frame': 'CY2010Q1I'}, {'end': '2010-08-28', 'val': 2433050000, 'accn': '0000950123-10-095687', 'fy': 2010, 'fp': 'FY', 'form': '10-K', 'filed': '2010-10-25'}</p>
  </blockquote>
  <p>Is there any way I would go about syncing up the fiscal years using the data provided? The only way I could think to sync it is by grabbing the start date and telling it to print it out according to the other company's start date, but I see no start date.</p>