How to fetch input from the csv file in python

Question

I have a csv (input.csv) file as shown below:

VM IP Naa_Dev Datastore
vm1 xx.xx.xx.x1 naa.ab1234 ds1
vm2 xx.xx.xx.x2 naa.ac1234 ds1
vm3 xx.xx.xx.x3 naa.ad1234 ds2

I want to use this csv file as an input file for my python script. Here in this file, first line i.e. (VM IP Naa_Dev Datastore) is the column heading and each value is separated by space.

So my question is how we can use this csv file for input values in python so if I need to search in python script that what is the value of vm1 IP then it should pickup xx.xx.xx.x1 or same way if I am looking for VM which has naa.ac1234 Naa_Dev should take vm2.

I am using Python version 2.7.8

Any help is much appreciated.

Thanks

You can look into Pandas

Ankit S
– Ankit S

2018-08-09 09:41:47 +00:00
Commented Aug 9, 2018 at 9:41 — Ankit S
– Ankit S, Commented Aug 9, 2018 at 9:41
Did you even Google? docs.python.org/2/library/csv.html

Alastair McCormack
– Alastair McCormack

2018-08-09 10:47:10 +00:00
Commented Aug 9, 2018 at 10:47 — Alastair McCormack
– Alastair McCormack, Commented Aug 9, 2018 at 10:47

hunzter · Accepted Answer · 2018-08-09 09:45:03Z

0

Working with tabular data like this, the best way is using pandas.

Something like:

import pandas
dataframe = pandas.read_csv('csv_file.csv')

# finding IP by vm
print(dataframe[dataframe.VM == 'vm1'].IP)
# OUTPUT: xx.xx.xx.x1

# or find by Naa_Dev
print(dataframe[dataframe.Naa_Dev == 'xx.xx.xx.x2'].VM)
# OUTPUT: vm2

answered Aug 9, 2018 at 9:45

hunzter

5984 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

learning Over a year ago

Thanks, this exactly matches to my requirements.

Piotrek · Accepted Answer · 2018-08-09 09:47:00Z

0

For importing csv into python you can use pandas, in your case the code would look like:

import pandas as pd
df = pd.read_csv('input.csv', sep=' ')

and for locating certain rows in created dataframe you can multiple options (that you can easily find in pandas or just by googling 'filter data python'), for example:

df['VM'].where(df['Naa_Dev'] == 'naa.ac1234')

answered Aug 9, 2018 at 9:47

Piotrek

1,54012 silver badges18 bronze badges

Comments

Noah M. · Accepted Answer · 2018-08-09 09:59:16Z

0

Use the pandas module to read the file into a DataFrame. There is a lot of parameters for reading csv files with pandas.read_csv. The dataframe.to_string() function is extremely useful.

Solution: # import module with alias 'pd' import pandas as pd

# Open the CSV file, delimiter is set to white space, and then
# we specify the column names.
dframe = pd.read_csv("file.csv",
                     delimiter=" ",
                     names=["VM", "IP", "Naa_Dev", "Datastore"])
# print will output the table
print(dframe)

# to_string will allow you to align and adjust content
# e.g justify = left to align columns to the left.
print(dframe.to_string(justify="left"))

edited Aug 9, 2018 at 9:59

answered Aug 9, 2018 at 9:47

Noah M.

3401 silver badge8 bronze badges

Comments

José Pedro Duarte · Accepted Answer · 2018-08-09 10:42:44Z

0

Pandas is probably the best answer but you can also:

import csv
your_list = []
with open('dummy.csv') as csvfile:
    reader = csv.DictReader(csvfile, delimiter=' ')
    for row in reader:
        your_list += [row]
print(your_list)

answered Aug 9, 2018 at 10:42

José Pedro Duarte

6510 bronze badges

Collectives™ on Stack Overflow

How to fetch input from the csv file in python

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related