python读excel成数组_如何使用python将Excel数据读取到数组中

最新推荐文章于 2024-02-03 23:25:02 发布

weixin_39789370

最新推荐文章于 2024-02-03 23:25:02 发布

阅读量2.6k

点赞数

文章标签： python读excel成数组

本文介绍如何利用Python的Pandas库将Excel文件读取为DataFrame对象，以便进行数据分析和操作。通过调用`pd.read_excel()`函数，可以轻松地将.xlsx文件转换为DataFrame，并进行各种计算和可视化。

摘要由CSDN通过智能技术生成

In the lab that I work in, we process a lot of data produced by a 96 well plate reader. I'm trying to write a script that will perform a few calculations and output a bar graph using matplotlib.

The problem is that the plate reader outputs data into a .xlsx file. I understand that some modules like pandas have a read_excel function, can you explain how I should go about reading the excel file and putting it into a dataframe?

Thanks

Data sample of a 24 well plate (for simplicity):

0.0868 0.0910 0.0912 0.0929 0.1082 0.1350

0.0466 0.0499 0.0367 0.0445 0.0480 0.0615

0.6998 0.8476 0.9605 0.0429 1.1092 0.0644

0.0970 0.0931 0.1090 0.1002 0.1265 0.1455

解决方案

This task is super easy in Pandas these days.

import pandas as pd

df = pd.read_excel('file_name_here.xlsx', sheet_name