How do I read and write tabular data?

[Devansh2290]

Pandas version checks

• I have checked that the issue still exists on the latest versions of the docs on main here

Location of the documentation

https://pandas.pydata.org/docs/getting_started/intro_tutorials/02_read_write.html

Documentation problem

Hi,
I have just started learning about pandas with "Getting Started tutorials". On the "How do I read and write tabular data?" tutorial when I ran the command got an unexpected error and no suggestion was provided there to solve this issue. The command and error are as follows:

Command: titanic.to_excel('titanic.xlsx', sheet_name='Passengers', index=False)

Error: ModuleNotFoundError: No module named 'openpyxl'

I solved the issue by installing openpyxl using pip with pip install openpyxl.

If this is an essential package for the tutorial, it should be mentioned in the document, so I'm creating this ticket.

Suggested fix for documentation

There should be a note in the document with the install command or it should be there as a step before reaching that point as a required step to following the tutorial.

[rhshadrach]

Thanks for the report. Agreed a line about installing an Excel reader would be a good improvement. I recommend it link to the installation instructions:

https://pandas.pydata.org/docs/getting_started/install.html#excel-files

[jmbenson]

take