Python Panda (Page: 5)

Go to Page:

1. Panda Series;
2. Pandas DataFrame: Creation;
3. Pandas: Create test DataFrame;
4. Pandas DataFrame: Add/Remove;
5. Pandas DataFrame: Export/Import;
6. Panda search and select;
7. Pandas Cheat Sheet;
8. Pandas: MultiIndex DataFrame;

Export and Import Panda DataFrame to other formats

Saving panda DataFrame into a different file formats is very powerful and useful tool for further storage and presentation of these data.

Save panda to CSV file

CSV is a common file for storage table data

data = {'Number' : ['zero', 'one', 'two', 'three', 'four', 'five', 'six'],
        'Roman'  : ['O', 'I', 'II', 'III', 'IV', 'V', 'VI'],
        'Arabic' : [0, 1, 2, 3, 4, 5, 6],
       }
numbers_df = pd.DataFrame(data)
# write to CSV file
numbers_df.to_csv('dataset/numbers.csv',
                       index = False)

Read CSV file to panda DataFrame

Reading is very easy as well. For reading, it is possible to specify the separator, and also it is possible to give format of digits – some use coma instead of dot as a decimal separator. For example sep = ';' - this parameter will use ; as a separator. In fact you can use any symbol as a separator

# read from CSV file
df = pd.read_csv('dataset/numbers.csv')

Saving to Microsoft Excel tables

Microsoft Excel tables are very popular for data representation and for some analysis. Python can save panda DataFrame to Microsoft Excel tables

writer = pd.ExcelWriter('./dataset/numbers.xlsx', engine='xlsxwriter')
numbers_df.to_excel(writer, sheet_name='Sheet1')

Microsoft Exel Simple format of Microsoft Excel after panda DataFrame conversion

Saving to HTML

HTML is very popular format for presentation in the WEB. Panda DataFrame can be saved as HTML file.

numbers_df.to_html('./dataset/numbers.html',
                  index = False)

HTML file Simple HTML after panda DataFrame conversion

Go to Page: 1; 2; 3; 4; 5; 6; 7; 8;

Published: 2021-11-05 09:11:16
Updated: 2021-12-17 02:48:39

Last 10 artitles

• 2023-12-25 01:48:38 - In-place and out-place Numpy functions
• 2023-12-25 00:58:08 - First order ordinary differential equations
• 2023-12-25 00:22:15 - How to increase swap space in Ubuntu
• 2023-12-24 04:03:12 - How to accelerate math calculations with Numba and Cython
• 2023-12-19 00:38:20 - 3 ways of function caching in Python
• 2023-12-19 00:16:55 - Accelerating Python
• 2023-12-16 12:26:55 - BioPython
• 2023-12-02 11:05:34 - Reading FITS files with astropy
• 2023-12-02 05:23:42 - Astropy
• 2023-12-01 00:33:16 - Circle length calculation with the Monte-Carlo method

9 popular artitles

• Python Panda (3438)
• Python NumPy (2979)
• Python DICTionary HowTo (1591)
• Python LIST HowTo (1469)
• Python (1422)
• Python Generators (1281)
• Python: How to make absolute links in BeautifulSoup (1084)
• Programming language (967)
• NumPy: What the difference between mgrid and meshgrid (946)