Scribd
Upload
38 views2 pages

Give The Table Data Into Downloadable Excel File

The document provides Python code to create and download an Excel file named 'table_data.xlsx' containing financial data. The data includes current assets, inventories, prepaid expenses, quick assets, current liabilities, and quick ratios for fiscal years ending in March from 2019 to 2024. Users are instructed to run the code in a Python environment with the necessary libraries installed to generate the file.

Uploaded by

monsoonbliss01
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
38 views2 pages

Give The Table Data Into Downloadable Excel File

The document provides Python code to create and download an Excel file named 'table_data.xlsx' containing financial data. The data includes current assets, inventories, prepaid expenses, quick assets, current liabilities, and quick ratios for fiscal years ending in March from 2019 to 2024. Users are instructed to run the code in a Python environment with the necessary libraries installed to generate the file.

Uploaded by

monsoonbliss01
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

GIVE THE TABLE DATA INTO DOWNLOADABLE

EXCEL FILE
You can create and download the Excel file using the provided Python code. Here's how you can
do it:

Steps to Generate the Excel File:


1. Copy the following Python code.
2. Run it in your Python environment (with pandas and openpyxl libraries installed).
3. The file will be saved as table_data.xlsx in your working directory.

import pandas as pd

# Data for the table


data = {
'Year (March Ending)': ['202003 (FY 2019-20)', '202103 (FY 2020-21)', '202203 (FY 202
'Current Assets (₹ Cr)': [19331.9, 17768.5, 19317.1, 18846.4, 24153.79],
'Inventories (₹ Cr)': [8038.07, 9470.87, 9997.77, 10593.9, 12631.51],
'Prepaid Expenses (₹ Cr)': [0, 0, 0, 0, 0],
'Quick Assets (₹ Cr)': [11293.83, 8297.63, 9319.33, 8252.5, 11522.28],
'Current Liabilities (₹ Cr)': [9022.28, 10122.2, 11431.3, 12367.8, 12367.35],
'Quick Ratio': [1.25, 0.82, 0.82, 0.67, 0.93]
}

# Create a DataFrame
df = pd.DataFrame(data)

# Save to Excel
df.to_excel("table_data.xlsx", index=False)

Output:
The file table_data.xlsx will contain the following data:

Current Prepaid Quick Current


Year (March Inventories Quick
Assets (₹ Expenses (₹ Assets (₹ Liabilities (₹
Ending) (₹ Cr) Ratio
Cr) Cr) Cr) Cr)

202003 (FY
19331.9 8038.07 0 11293.83 9022.28 1.25
2019-20)

202103 (FY
17768.5 9470.87 0 8297.63 10122.2 0.82
2020-21)

202203 (FY
19317.1 9997.77 0 9319.33 11431.3 0.82
2021-22)
Current Prepaid Quick Current
Year (March Inventories Quick
Assets (₹ Expenses (₹ Assets (₹ Liabilities (₹
Ending) (₹ Cr) Ratio
Cr) Cr) Cr) Cr)

202303 (FY
18846.4 10593.9 0 8252.5 12367.8 0.67
2022-23)

202403 (FY
24153.79 12631.51 0 11522.28 12367.35 0.93
2023-24)

You can now use this file for further analysis or sharing!
⁂

You might also like