473,396 Members | 2,033 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

converting columns of a file(say excel ) into separate lists

I have an excel file and I want to read each column and create separate lists for them. I want to then compare each element of each list with other corresponding lists I have.
Is there a way I can convert the columns into lists using python?
Jun 29 '12 #1
1 2914
dwblas
626 Expert 512MB
There is a python-excel website that contain tools that allow you to read and write excel files, so you can read the excel file into a list or do anything else required.
Jun 29 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Viswa | last post by:
PythonGurus, I would like to read the ascii data from a file with many columns into a list. I want the type to be float. data=open('dat1.dat','r') lines=data.readlines() print lines
5
by: Axial | last post by:
Question: How to select columns from Excel-generated XML when some cells are empty. I've found examples where rows are to be selected, but I can't seem to extrapolate from that to selecting...
2
by: subhashnegi | last post by:
Hi, I am tranforming an xml file to excel spreadsheet using xslt. But the problem is that I want to have hyperlinks in one of the columns of excel spreadsheet. Can anyone please tell me the tag...
3
by: mkopcic | last post by:
Hi all! I need help with Visual Basic Application 6.0 and Excel. Problem is that I need group some columns in Excel by Macro in VBA. Columns are not fixed which mean that every time when a program...
2
by: nalamveena | last post by:
I am able to export to excel through a stored procedure.But when i open it the datetime column and int columns are not getting recognised.
0
by: JFKJr | last post by:
I have an excel file, which has columns C and D grouped together, I am trying to delete blank columns and rows from the excel file, ungroup the columns and import the file to MS Access using Access...
2
by: DeelynBaNi | last post by:
Hi all...i'm having a problem in formatting columns in excel. For example i have column Name, Birth Date and Salary and i want to format it to string, date and numeric respectively. When i format the...
3
by: Will | last post by:
Can someone help with code to delete multiple columns from an excel spreadsheet? I know which columns I need to delete. The code below will delete a single column but I'm not sure how to delete...
3
by: ronakinuk | last post by:
how can i unhide rows/columns in excel 2007
2
by: Amanda Ahl | last post by:
How can I divide a file with emails divided with headers like this: From: jdakl@hotmail.com Sent: 7th aprill 2099 To: hjfdaso@hotmail.com email text ...into separate lists in one big list...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.