DataCamp/dfloop.py at master · shariful-cu/DataCamp · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Created on Tue Jun  5 02:16:00 2018

@author: Shariful
"""

import pandas as pd

# Import the cars.csv data: cars
file_path = '/Users/Shariful/Documents/CyberAttackDatasets/PowerSystemData/binaryAllNaturalPlusNormalVsAttacks/data1.csv'
powerdb = pd.read_csv(file_path)

#accessing subset from the whole powerdb dataset
powerdb = powerdb.iloc[:1,:]

##accessing all column names
#for colname in powerdb :
#    print(colname)
#
##accessing each row
#for lab, row in powerdb.iterrows() :
#    print(lab)
#    print(row)

#
## Adapt for loop
#for lab, row in powerdb.iterrows() :
#    print(str(lab) + ': ' + str(row['R1-PA1:VH']))
#

# Adding new column using .apply(apply_function name)
for lab, row in powerdb.iterrows() :
    powerdb['R1-PA1:VH_Int'] = powerdb['R1-PA1:VH'].apply(int)

print(powerdb)