Hello Everyone, I am doing a task in which I import a excel tabular data into python environment using CSV module. I have been successful in doing the same. I would like to know if it possible to display only a certain column by making it to an array or something else. I do not want to display the HEADER data with the names. I attached you the sample data and for example if I just type the name ‘Node’ in the command window will I be able to get the column values of the ‘Node’ as an array or a list. If yes then that would be very great help for me. Thank you in advance for your time and patience. here is the code for the table. Here in france we say to float number 30.7 as 30,7.
R=[30,7 30,7 30,7]
Node R T
270 30,7 0,0
497 30,7 0,07
4971 30,7 0,13
import csv
import pprint
filename='C:\\Scratch\\998\\20_calculation\\CASE200.csv'
infile=open(filename,'r')
table = [row for row in csv.reader(infile,delimiter=' / ')]
pprint.pprint(table)
I think that Pandas will help you a lot with this. Take a look: https://stackoverflow.com/questions/26063231/read-specific-columns-with-pandas-or-other-python-module
Thank you Vitor. Yes pandas will do itbut unfortunately I can't be able to import PANDAS module in Abaqus(simulation software with built in Python).
- Badges
- Science topic
- Similar topics
- Computer Science and Engineering
- Programming Languages
- Python