plot with value of all groups of variables year wise

General
,
1

The plot shared is the z-score of banks throughout the time period in the study.
code

zs_private_banks <- aggregate(x = data_private$z_score,
by = list(data_private$bank),
FUN = mean)

ggplot(zs_private_banks, aes(x=Group.1, y=x)) +
geom_point(color="green4", size=5, alpha=0.9,)+
geom_hline(yintercept = 0,size=1.0,linetype=5)+
ggtitle("Average z-score")+
xlab("Banks") +
ylab("z score") +
geom_text(aes(label=Group.1),hjust=0, vjust=0)

How can I make a plot where I can plot individual banks z-score for each year with year on the x-axis and score on the y-axis?

I would be highly grateful.

data

bank ownership year z_score
ALD public 1991 0.187
ALD public 1992 0.283
ALD public 1993 0.337
ALD public 1994 -0.012
ALD public 1995 0.275
ALD public 1996 0.398
ALD public 1997 0.516
ALD public 1998 9.153
ALD public 1999 0.531
ALD public 2000 29.22
ALD public 2001 4.054
ALD public 2002 17.097
ALD public 2003 15.463
ALD public 2004 6.624
ALD public 2005 7.012
ALD public 2006 6.535
ALD public 2007 6.913
ALD public 2008 6.748
ALD public 2009 8.688
ALD public 2010 7.21
ALD public 2011 7.394
ALD public 2012 7.853
ALD public 2013 13.442
ALD public 2014 17.353
ALD public 2015 12.689
ALD public 2016 -1.689
ALD public 2017 -0.654
ALD public 2018 -3.629
ALD public 2019 -3.94
ANB public 1991 0.106
ANB public 1992 0.163
ANB public 1993 0.008
ANB public 1994 -0.007
ANB public 1995 0.137
ANB public 1996 0.131
ANB public 1997 8.855
ANB public 1998 37.435
ANB public 1999 521.969
ANB public 2000 296.436
ANB public 2001 15.944
ANB public 2002 23.932
ANB public 2003 9.149
ANB public 2004 8.775
ANB public 2005 9.446
ANB public 2006 11.206
ANB public 2007 12.013
ANB public 2008 14.74
ANB public 2009 16.895
ANB public 2010 10.931
ANB public 2011 11.298
ANB public 2012 14.013
ANB public 2013 22.567
ANB public 2014 3.318
ANB public 2015 5.143
ANB public 2016 3.155
ANB public 2017 0.86
ANB public 2018 -2.981
ANB public 2019 -2.622
AXIS private 1995 0.804
AXIS private 1996 0.414
AXIS private 1997 0.329
AXIS private 1998 0.196
AXIS private 1999 10.053
AXIS private 2000 9.139
AXIS private 2001 10.142
AXIS private 2002 121.89
AXIS private 2003 1363.1
AXIS private 2004 27.34
AXIS private 2005 162.591
AXIS private 2006 960.056
AXIS private 2007 70.906
AXIS private 2008 91.778
AXIS private 2009 26.008
AXIS private 2010 16.253
AXIS private 2011 15.927
AXIS private 2012 15.941
AXIS private 2013 15.66
AXIS private 2014 14.217
AXIS private 2015 13.461
AXIS private 2016 15.265
AXIS private 2017 6.494
AXIS private 2018 0.532
AXIS private 2019 6.007
AXIS private 2020 1.378
BENARAS private 1992 0.014
BENARAS private 1993 -0.111
BENARAS private 1994 -0.092
BENARAS private 1995 0.128
BENARAS private 1996 0.026
BENARAS private 1997 0.031
BENARAS private 1998 0.319
BENARAS private 2000 -27.69
BENARAS private 2001 -2.651
BANDHAN private 2015 0.506
BANDHAN private 2016 2.18
BANDHAN private 2017 13.163
BANDHAN private 2018 31.42
BANDHAN private 2019 18.157
BANDHAN private 2020 20.692
BOB public 1991 0.128
BOB public 1992 0.167
BOB public 1993 0.175
BOB public 1994 0.281
BOB public 1995 0.282
BOB public 1996 0.364
BOB public 1997 0.382
BOB public 1998 0.421
BOB public 1999 0.402
BOB public 2000 16.244
BOB public 2001 12.345
BOB public 2002 22.147
BOB public 2003 12.113
BOB public 2004 10.165
BOB public 2005 31.63
BOB public 2006 25.035
BOB public 2007 23.572
BOB public 2008 16.948
BOB public 2009 11.493
BOB public 2010 10.036
BOB public 2011 9.077
BOB public 2012 9.782
BOB public 2013 16.375
BOB public 2014 31.355
BOB public 2015 17.477
BOB public 2016 -2.356
BOB public 2017 2.678
BOB public 2018 -1.338
BOB public 2019 0.956
BOB public 2020 0.935
BOI public 1991 0.27
BOI public 1992 0.299
BOI public 1993 0.153
BOI public 1994 -0.052
BOI public 1995 0.282
BOI public 1996 0.314
BOI public 1997 10.166
BOI public 1998 12.797
BOI public 1999 30.668
BOI public 2000 10.721
BOI public 2001 76.166
BOI public 2002 12.85
BOI public 2003 8.527
BOI public 2004 8.129
BOI public 2005 23.045
BOI public 2006 16.898
BOI public 2007 11.008
BOI public 2008 8.165
BOI public 2009 7.41
BOI public 2010 15.929
BOI public 2011 12.128
BOI public 2012 15.139
BOI public 2013 19.1
BOI public 2014 68.744
BOI public 2015 7.702
BOI public 2016 -3.116
BOI public 2017 -1.361
BOI public 2018 -3.055
BOI public 2019 -1.992
BOI public 2020 -2.03
BOM public 1993 0.007
BOM public 1994 -0.508
BOM public 1995 0.413
BOM public 1996 0.586
BOM public 1997 10.105
BOM public 1998 10.561
BOM public 1999 14.902
BOM public 2000 9.749
BOM public 2001 34.684
BOM public 2002 8.577
BOM public 2003 7.391
BOM public 2004 7.222
BOM public 2005 10.907
BOM public 2006 8.785
BOM public 2007 8.151
BOM public 2008 8.144
BOM public 2009 8.345
BOM public 2010 8.495
BOM public 2011 12.757
BOM public 2012 10.541
BOM public 2013 8.232
BOM public 2014 72.186
BOM public 2015 34.827
BOM public 2016 2.76
BOM public 2017 -3.54
BOM public 2018 -3.278
BOM public 2019 -4.447
BOM public 2020 29.953
BOP private 1995 0.493
BOP private 1996 0.716
BOP private 1997 0.344
BOP private 1998 4.674
BOP private 1999 6.301
BOP private 2000 15.835
BOP private 2001 35.691
BOP private 2002 41.025
BOP private 2003 32.92
BOP private 2004 317.57
BOP private 2005 -1.543
BOP private 1993 0.136
BOP private 1994 0.203
BOP private 1995 0.276
BOP private 1996 0.312
BOP private 1997 0.289
BOP private 1998 0.16
BOP private 1999 0.045
BOP private 2000 3.368
BOP private 2001 17.755
BOP private 2002 11.733
BOP private 2003 7.096
BOP private 2004 12.41
BOP private 2005 5.928
BOP private 2006 1.724
BOP private 2007 6.771
BOP private 2008 9.681
BOP private 2009 17.789
BOP private 2010 -1.468
CSB private 2014 5.958
CSB private 2015 4.289
CSB private 2016 0.348
CAN public 1994 0.003
CAN public 1995 0.003
CAN public 1996 0.002
CAN public 1997 0.002
CAN public 1998 0.002
CAN public 1999 0.06
CAN public 2000 0.003
CAN public 2001 0.003
CAN public 2002 1.81
CAN public 2003 1.905
CAN public 2004 2.027
CAN public 2005 0.602
CAN public 2006 0.349
CAN public 2007 0.86
CAN public 2008 1.3
CAN public 2009 1.198
CAN public 2010 0.061
CAN public 2011 0.374
CAN public 2012 0.601
CAN public 2013 0.623
CAN public 2014 0.468
CAN public 2015 -4.561
CAN public 2016 -6.782
CAN public 2017 0.033
CAN public 2018 -2.788
CAN public 2019 -12.924
CAN public 2020 0.2
CBI public 1995 0.59
CBI public 1996 0.592
CBI public 1997 0.551
CBI public 1998 15.021
CBI public 1999 14.824
CBI public 2000 10.978
CBI public 2001 10.577
CBI public 2002 13.137
CBI public 2003 10.234
CBI public 2004 9.513
CBI public 2005 13.89
CBI public 2006 11.701
CBI public 2007 14.699
CBI public 2008 16.502
CBI public 2009 12.582
CBI public 2010 9.719
CBI public 2011 9.047
CBI public 2012 15.708
CBI public 2013 30.75
CBI public 2014 29.354
CBI public 2015 33.236
CBI public 2016 -1.758
CBI public 2017 3.039
CBI public 2018 -2.231
CBI public 2019 1.212
CBI public 2020 -1.113
CBP private 1995 138.571
CBP private 1996 60.707
CBP private 1997 40.217
CBP private 1998 28.569
CBP private 1999 10.621
CBP private 2000 9.881
CBP private 2001 277.107
CBP private 2002 11.136
CBP private 2003 9.53
CBP private 2004 8.413
CBP private 2005 11.874
CBP private 2006 10.501
CBP private 2007 6.586
CUB private 1995 1.612
CUB private 1996 1.32
CUB private 1997 1.172
CUB private 1998 1.009
CUB private 1999 2.377
CUB private 2000 2.37
CUB private 2001 1.559
CUB private 2002 -3.113
CUB private 2003 -5.168
CUB private 2004 -3.129
CUB private 2005 2.278
CUB private 2006 2.605
CUB private 2007 2.68
CORP public 1991 0.116
CORP public 1992 0.15
CORP public 1993 0.197
CORP public 1994 0.238
CORP public 1995 0.221
CORP public 1996 0.316
CORP public 1997 0.328
CORP public 1998 0.506
CORP public 1999 9.202
CORP public 2000 8.625
CORP public 2001 8.578
CORP public 2002 8.452
CORP public 2003 7.556
CORP public 2004 7.387
CORP public 2005 12.759
CORP public 2006 10.935
CORP public 2007 11.74
CORP public 2008 10.26
CORP public 2009 10.712
CORP public 2010 10.264
CORP public 2011 10.978
CORP public 2012 13.563
CORP public 2013 21.866
CORP public 2014 3.88
CORP public 2015 3.688
CORP public 2016 -0.924
CORP public 2017 2.802
CORP public 2018 -3.16
CORP public 2019 -3.674
CORP public 2020 -2.711
DCB private 1993 1.508
DCB private 1994 1.55
DCB private 1995 1.744
DCB private 1996 2.097
DCB private 1997 1.399
DCB private 1998 6.172
DCB private 1999 8.093
DCB private 2000 7.756
DCB private 2001 9.912
DCB private 2002 9.137
DCB private 2003 9.937
DCB private 2004 35.927
DCB private 2005 -4.12
DCB private 2006 -3.8
DCB private 2007 4.249
DCB private 2008 48.149
DCB private 2009 -3.247
DCB private 2010 -3.295
DCB private 2011 14.09
DCB private 2012 14.227
DCB private 2013 8.454
DCB private 2014 7.396
DCB private 2015 7.274
DCB private 2016 8.078
DCB private 2017 9.394
DCB private 2018 9.335
DCB private 2019 8.887
DCB private 2020 9.708
DENA public 1993 0.106
DENA public 1994 0.156
DENA public 1995 0.164
DENA public 1996 0.225
DENA public 1997 0.346
DENA public 1998 18.864
DENA public 1999 35.088
DENA public 2000 6.729
DENA public 2001 0.009
DENA public 2002 0.505
DENA public 2003 52.857
DENA public 2004 10.819
DENA public 2005 3.359
DENA public 2006 3.986
DENA public 2007 55.368
DENA public 2008 11.729
DENA public 2009 12.524
DENA public 2010 12.768
DENA public 2011 13.038
DENA public 2012 11.442
DENA public 2013 18.807
DENA public 2014 17.312
DENA public 2015 2.744
DENA public 2016 -2.539
DENA public 2017 165.36
DENA public 2018 7.692
DLB private 1995 2.304
DLB private 1996 3.036
DLB private 1997 5.73
DLB private 1998 5.371
DLB private 1999 2.822
DLB private 2000 5.631
DLB private 2001 6.488
DLB private 2002 6.131
DLB private 2003 5.711
DLB private 2004 5.694
DLB private 2005 -4.068
DLB private 2006 6.947
DLB private 2007 6.098
DLB private 2008 5.503
DLB private 2009 5.335
DLB private 2010 7.026
DLB private 2011 9.043
DLB private 2012 -3.94
DLB private 2013 5.893
DLB private 2014 -4.373
DLB private 2015 -4.36
DLB private 2016 -4.355
DLB private 2017 35.895
DLB private 2018 -2.52
DLB private 2019 35.801
DLB private 2020 6.048
FED private 1990 0.045
FED private 1991 0.056
FED private 1992 0.047
FED private 1993 0.058
FED private 1994 0.122
FED private 1995 0.207
FED private 1996 0.238
FED private 1997 0.29
FED private 1998 12.641
FED private 1999 0.351
FED private 2000 8.75
FED private 2001 12.606
FED private 2002 25.457
FED private 2003 39.234
FED private 2004 64.183
FED private 2005 9.067
FED private 2006 20.759
FED private 2007 16.854
FED private 2008 18.948
FED private 2009 14.972
FED private 2010 33.566
FED private 2011 18.669
FED private 2012 16.409
FED private 2013 18.183
FED private 2014 26.993
FED private 2015 19.385
FED private 2016 7.848
FED private 2017 33.742
FED private 2018 18.235
FED private 2019 51.085
FED private 2020 160.858
GTB private 1994 7.563
GTB private 1995 0.901
GTB private 1996 0.486
GTB private 1997 0.525
GTB private 1998 2.353
GTB private 1999 2.584
GTB private 2000 0.531
GTB private 2001 3.113
GTB private 2002 4.222
GTB private 2003 -1.862
HDFC private 1995 2.196
HDFC private 1996 0.623
HDFC private 1997 0.376
HDFC private 1998 21.757
HDFC private 1999 54.318
HDFC private 2000 73.835
HDFC private 2001 83.667
HDFC private 2002 31.711
HDFC private 2003 38.962
HDFC private 2004 27.268
HDFC private 2005 30.354
HDFC private 2006 20.71
HDFC private 2007 17.388
HDFC private 2008 17.02
HDFC private 2009 14.974
HDFC private 2010 41.887
HDFC private 2011 58.834
HDFC private 2012 165.828
HDFC private 2013 51.952
HDFC private 2014 35.298
HDFC private 2015 33.551
HDFC private 2016 54.875
HDFC private 2017 58.093
HDFC private 2018 45.544
HDFC private 2019 52.719
HDFC private 2020 34.64
ICICI private 1995 0.914
ICICI private 1996 0.53
ICICI private 1997 0.401
ICICI private 1998 22.43
ICICI private 1999 15.812
ICICI private 2000 13.991
ICICI private 2001 11.14
ICICI private 2002 6.542
ICICI private 2003 88.859
ICICI private 2004 55.03
ICICI private 2005 25.397
ICICI private 2006 60.858
ICICI private 2007 52.814
ICICI private 2008 79.37
ICICI private 2009 24.447
ICICI private 2010 94.626
ICICI private 2011 44.391
ICICI private 2012 24.806
ICICI private 2013 16.877
ICICI private 2014 15.204
ICICI private 2015 13.952
ICICI private 2016 25.431
ICICI private 2017 44.079
ICICI private 2018 14.312
ICICI private 2019 2.913
ICICI private 2020 11.179
IDBI public 1991 286.412
IDBI public 1992 277.224
IDBI public 1993 289.243
IDBI public 1994 303.57
IDBI public 1995 305.523
IDBI public 1996 440.566
IDBI public 1997 441.277
IDBI public 1998 429.071
IDBI public 1999 394.895
IDBI public 2000 4.905
IDBI public 2001 5.061
IDBI public 2002 5.204
IDBI public 2003 5.264
IDBI public 2004 5.029
IDBI public 2005 4.896
IDBI public 2006 4.952
IDBI public 2007 4.881
IDBI public 2008 4.828
IDBI public 2009 4.794
IDBI public 2010 4.781
IDBI public 2011 4.788
IDBI public 2012 4.807
IDBI public 2013 4.856
IDBI public 2014 5.216
IDBI public 2015 5.479
IDBI public 2016 -4.225
IDBI public 2017 4.631
IDBI public 2018 -4.386
IDBI public 2019 -4.379
IDBI public 2020 -4.374
IDFC private 2015 -2.663
IDFC private 2016 2.233
IDFC private 2017 2.172
IDFC private 2018 2.217
IDFC private 2019 -1.879
IDFC private 2020 -1.926
INDIAN public 1989 0.081
INDIAN public 1990 0.075
INDIAN public 1991 0.108
INDIAN public 1992 0.131
INDIAN public 1993 0.111
INDIAN public 1994 0.062
INDIAN public 1995 0.132
INDIAN public 1996 -0.276
INDIAN public 1997 -0.422
INDIAN public 1998 0.039
INDIAN public 1999 -0.142
INDIAN public 2000 -0.233
INDIAN public 2001 -0.325
INDIAN public 2002 0.69
INDIAN public 2003 11.511
INDIAN public 2004 17.94
INDIAN public 2005 28.312
INDIAN public 2006 20.765
INDIAN public 2007 11.95
INDIAN public 2008 10.129
INDIAN public 2009 10.295
INDIAN public 2010 9.908
INDIAN public 2011 11.107
INDIAN public 2012 14.812
INDIAN public 2013 41.542
INDIAN public 2014 13.465
INDIAN public 2015 7.201
INDIAN public 2016 3.399
INDIAN public 2017 13.57
INDIAN public 2018 6.861
INDIAN public 2019 0.987
INDIAN public 2020 2.168
IOB public 1990 0.624
IOB public 1991 0.704
IOB public 1992 0.738
IOB public 1995 0.526
IOB public 1996 0.462
IOB public 1997 0.534
IOB public 1998 10.339
IOB public 1999 24.074
IOB public 2000 6.207
IOB public 2001 18.606
IOB public 2002 8.48
IOB public 2003 6.658
IOB public 2004 6.552
IOB public 2005 6.22
IOB public 2006 6.18
IOB public 2007 6.106
IOB public 2008 6.187
IOB public 2009 6.418
IOB public 2010 10.789
IOB public 2011 8.226
IOB public 2012 11.029
IOB public 2013 34.602
IOB public 2014 26.874
IOB public 2015 -1.188
IOB public 2016 -3.461
IOB public 2017 -3.664
IOB public 2018 -4.108
IOB public 2019 6.156
IOB public 2020 -4.208
INDUS private 1995 0.649
INDUS private 1996 0.452
INDUS private 1997 0.289
INDUS private 1998 16.702
INDUS private 1999 4.78
INDUS private 2000 6.275
INDUS private 2001 3.113
INDUS private 2002 3.368
INDUS private 2003 12.543
INDUS private 2004 18.011
INDUS private 2005 32.097
INDUS private 2006 1.198
INDUS private 2007 1.962
INDUS private 2008 1.948
INDUS private 2009 4.275
INDUS private 2010 42.345
INDUS private 2011 8.554
INDUS private 2012 26.037
INDUS private 2013 22.746
INDUS private 2014 16.677
INDUS private 2015 14.899
INDUS private 2016 14.956
INDUS private 2017 15.769
INDUS private 2018 15.006
INDUS private 2019 59.545
INDUS private 2020 29.024
JKB public 1993 0.144
JKB public 1994 0.174
JKB public 1995 0.196
JKB public 1996 0.201
JKB public 1997 0.207
JKB public 1998 0.244
JKB public 1999 0.282
JKB public 2000 0.248
JKB public 2001 13.606
JKB public 2002 8.976
JKB public 2003 8.035
JKB public 2004 8.358
JKB public 2005 5.715
JKB public 2006 15.356
JKB public 2007 55.749
JKB public 2008 24.026
JKB public 2009 24.012
JKB public 2010 17.283
JKB public 2011 16.499
JKB public 2012 10.427
JKB public 2013 9.391
JKB public 2014 9.183
JKB public 2015 18.953
JKB public 2016 9.155
JKB public 2017 -2.954
JKB public 2018 2.159
JKB public 2019 6.148
JKB public 2020 -2.313
KAR private 1991 0.072
KAR private 1992 0.085
KAR private 1993 0.103
KAR private 1994 0.109
KAR private 1995 0.121
KAR private 1996 0.304
KAR private 1997 0.298
KAR private 1998 11.062
KAR private 1999 1104.372
KAR private 2000 19.761
KAR private 2001 15.573
KAR private 2002 20.985
KAR private 2003 19.565
KAR private 2004 17.617
KAR private 2005 20.774
KAR private 2006 20.207
KAR private 2007 31.201
KAR private 2008 16.719
KAR private 2009 21.749
KAR private 2010 11.703
KAR private 2011 15.135
KAR private 2012 15.954
KAR private 2013 59.445
KAR private 2014 14.213
KAR private 2015 82.186
KAR private 2016 21.351
KAR private 2017 16.911
KAR private 2018 5.531
KAR private 2019 10.195
KAR private 2020 6.415
KARUR private 1991 0.086
KARUR private 1992 0.106
KARUR private 1993 0.112
KARUR private 1994 0.107
KARUR private 1995 0.116
KARUR private 1996 0.191
KARUR private 1997 0.206
KARUR private 1998 27.726
KARUR private 1999 24.836
KARUR private 2000 19.512
KARUR private 2001 22.175
KARUR private 2002 11.823
KARUR private 2003 13.331
KARUR private 2004 11.826
KARUR private 2005 308.955
KARUR private 2006 36.661
KARUR private 2007 73.7
KARUR private 2008 39.454
KARUR private 2009 115.944
KARUR private 2010 25.793
KARUR private 2011 29.533
KARUR private 2012 57.299
KARUR private 2013 86.75
KARUR private 2014 7.648
KARUR private 2015 8.232
KARUR private 2016 13.1
KARUR private 2017 11.891
KARUR private 2018 3.262
KARUR private 2019 1.691
KARUR private 2020 1.766
KOTAK private 1991 0.507
KOTAK private 1992 0.627
KOTAK private 1993 0.447
KOTAK private 1994 0.684
KOTAK private 1995 0.433
KOTAK private 1996 0.408
KOTAK private 1997 0.462
KOTAK private 1998 0.626
KOTAK private 1999 0.713
KOTAK private 2000 0.891
KOTAK private 2001 0.966
KOTAK private 2002 7.977
KOTAK private 2003 16.953
KOTAK private 2004 17.831
KOTAK private 2005 29.119
KOTAK private 2006 15.107
KOTAK private 2007 5.024
KOTAK private 2008 7.392
KOTAK private 2009 6.39
KOTAK private 2010 92.766
KOTAK private 2011 236.173
KOTAK private 2012 321.048
KOTAK private 2013 1409.275
KOTAK private 2014 1954.977
KOTAK private 2015 51.005
KOTAK private 2016 9.08
KOTAK private 2017 106.258
KOTAK private 2018 106.989
KOTAK private 2019 67.822
KOTAK private 2020 129.275
LVB private 1992 0.316
LVB private 1993 0.382
LVB private 1994 0.448
LVB private 1995 0.671
LVB private 1996 0.872
LVB private 1997 0.897
LVB private 1998 0.895
LVB private 1999 0.836
LVB private 2000 6.264
LVB private 2001 6.571
LVB private 2002 6.48
LVB private 2003 6.326
LVB private 2004 6.198
LVB private 2005 2.931
LVB private 2006 10.913
LVB private 2007 42.956
LVB private 2008 17.452
LVB private 2009 8.114
LVB private 2010 43.221
LVB private 2011 6.988
LVB private 2012 7.947
LVB private 2013 10.548
LVB private 2014 52.267
LVB private 2015 9.319
LVB private 2016 8.304
LVB private 2017 7.316
LVB private 2018 -3.649
LVB private 2019 -3.889
LVB private 2020 -3.961
NB private 1994 0.04
NB private 1995 0.038
NB private 1996 0.065
NB private 1997 0.102
NB private 1998 0.948
NB private 1999 0.821
NB private 2000 0.977
NB private 2001 -3.307
NB private 2002 0.127
NB private 2003 -2.839
PSB public 1994 -0.009
PSB public 1995 0.374
PSB public 1996 0.144
PSB public 1997 0.635
PSB public 1998 7.186
PSB public 1999 8.998
PSB public 2000 9.158
PSB public 2001 4.741
PSB public 2002 15.759
PSB public 2003 1.239
PSB public 2004 2.399
PSB public 2005 -3.005
PSB public 2006 8.1
PSB public 2007 6.55
PSB public 2008 5.868
PSB public 2009 6.058
PSB public 2010 6.347
PSB public 2011 6.668
PSB public 2012 7.877
PSB public 2013 11.043
PSB public 2014 15.705
PSB public 2015 8.438
PSB public 2016 17.107
PSB public 2017 39.584
PSB public 2018 -3.349
PSB public 2019 -2.917
PSB public 2020 -3.63
PNB public 1995 0.234
PNB public 1996 0.189
PNB public 1997 0.211
PNB public 1998 0.248
PNB public 1999 20.214
PNB public 2000 25.676
PNB public 2001 28.846
PNB public 2002 23.152
PNB public 2003 12.813
PNB public 2004 11.141
PNB public 2005 10.799
PNB public 2006 11.18
PNB public 2007 12.099
PNB public 2008 10.392
PNB public 2009 8.64
PNB public 2010 8.412
PNB public 2011 8.863
PNB public 2012 9.994
PNB public 2013 12.665
PNB public 2014 98.27
PNB public 2015 36.313
PNB public 2016 -2.147
PNB public 2017 2.739
PNB public 2018 -3.297
PNB public 2019 -3.024
PNB public 2020 0.905
RBL private 1997 0.143
RBL private 1998 0.173
RBL private 1999 0.188
RBL private 2000 65.59
RBL private 2001 30.457
RBL private 2002 19.953
RBL private 2003 12.419
RBL private 2004 22.972
RBL private 2005 -2.431
RBL private 2006 0.671
RBL private 2007 3.718
RBL private 2008 16.249
RBL private 2009 9.019
RBL private 2010 33.956
RBL private 2011 10.764
RBL private 2012 14.027
RBL private 2013 31.055
RBL private 2014 15.903
RBL private 2015 37.776
RBL private 2016 47.457
RBL private 2017 27.447
RBL private 2018 17.972
RBL private 2019 15.187
RBL private 2020 11.105
SBIC public 1995 0.359
SBIC public 1996 1.42
SBIC public 1997 3.539
SBIC public 1998 2.79
SBIC public 1999 3.226
SBIC public 2000 3.87
SBIC public 2001 -3.009
SBIC public 2002 6.843
SBIC public 2003 -2.534
SBIC public 2004 3.517
SBIC public 2005 -2.645
SBIC public 2006 4.45
SBIC public 2007 4.31
SBIC public 2008 3.818
SBIC public 2009 4.02
SBIC public 2010 7.258
SOUTH private 1995 0.215
SOUTH private 1996 0.219
SOUTH private 1997 0.198
SOUTH private 1998 0.211
SOUTH private 1999 0.262
SOUTH private 2000 23.806
SOUTH private 2001 37.887
SOUTH private 2002 17.147
SOUTH private 2003 12.288
SOUTH private 2004 21.187
SOUTH private 2005 0.893
SOUTH private 2006 10.538
SOUTH private 2007 41.646
SOUTH private 2008 20.934
SOUTH private 2009 16.635
SOUTH private 2010 17.387
SOUTH private 2011 18.184
SOUTH private 2012 15.364
SOUTH private 2013 14.065
SOUTH private 2014 21.516
SOUTH private 2015 12.57
SOUTH private 2016 11.83
SOUTH private 2017 13.457
SOUTH private 2018 6.261
SOUTH private 2019 3.147
SOUTH private 2020 1.086
SBBJ public 1993 0.075
SBBJ public 1994 0.067
SBBJ public 1995 0.059
SBBJ public 1996 0.1
SBBJ public 1997 0.1
SBBJ public 1998 0.171
SBBJ public 1999 0.173
SBBJ public 2000 38.602
SBBJ public 2001 17.164
SBBJ public 2002 38.71
SBBJ public 2003 25.589
SBBJ public 2004 11.373
SBBJ public 2005 56.791
SBBJ public 2006 5.589
SBBJ public 2007 77.455
SBBJ public 2008 48.049
SBBJ public 2009 148.988
SBBJ public 2010 245.447
SBBJ public 2011 283.428
SBBJ public 2012 94.67
SBBJ public 2013 287.161
SBBJ public 2014 48.917
SBBJ public 2015 33.949
SBBJ public 2016 30.756
SBH public 1991 0.055
SBH public 1992 0.061
SBH public 1993 0.078
SBH public 1994 0.082
SBH public 1995 0.112
SBH public 1996 0.119
SBH public 1997 0.123
SBH public 1998 0.143
SBH public 1999 0.147
SBH public 2000 0.156
SBH public 2001 19.469
SBH public 2002 136.964
SBH public 2003 28.937
SBH public 2004 19.369
SBH public 2005 16.275
SBH public 2006 32.694
SBH public 2007 30.772
SBH public 2008 404.189
SBH public 2009 46.078
SBH public 2010 104.401
SBH public 2011 21.337
SBH public 2012 29.166
SBH public 2013 36.49
SBH public 2014 10.139
SBH public 2015 36.865
SBH public 2016 8.121
SBI public 1989 0.042
SBI public 1990 0.039
SBI public 1991 0.042
SBI public 1992 0.038
SBI public 1993 0.041
SBI public 1994 7.194
SBI public 1995 5.783
SBI public 1996 5.777
SBI public 1997 0.127
SBI public 1998 0.133
SBI public 1999 1.63
SBI public 2000 3.149
SBI public 2001 1.768
SBI public 2002 2.999
SBI public 2003 3.914
SBI public 2004 4.6
SBI public 2005 5.087
SBI public 2006 4.206
SBI public 2007 3.811
SBI public 2008 5.365
SBI public 2009 5.643
SBI public 2010 4.154
SBI public 2011 2.924
SBI public 2012 4.154
SBI public 2013 4.944
SBI public 2014 2.623
SBI public 2015 2.788
SBI public 2016 1.676
SBI public 2017 1.458
SBI public 2018 -0.303
SBI public 2019 0.184
SBI public 2020 1.324
SBIN public 1993 0.053
SBIN public 1994 0.049
SBIN public 1995 0.053
SBIN public 1996 0.112
SBIN public 1997 0.114
SBIN public 1998 0.115
SBIN public 1999 0.109
SBIN public 2000 9.2
SBIN public 2001 15.143
SBIN public 2002 23.019
SBIN public 2003 7.91
SBIN public 2004 8.176
SBIN public 2005 19.088
SBIN public 2006 7.755
SBIN public 2007 13.566
SBIN public 2008 14.378
SBIN public 2009 14.414
SBM public 1993 0.058
SBM public 1994 0.048
SBM public 1995 8.742
SBM public 1996 7.967
SBM public 1997 0.148
SBM public 1998 44.438
SBM public 1999 4.999
SBM public 2000 0.156
SBM public 2001 1.85
SBM public 2002 9.412
SBM public 2003 63.718
SBM public 2004 17.329
SBM public 2005 18.699
SBM public 2006 19.757
SBM public 2007 32.761
SBM public 2008 37.037
SBM public 2009 109.11
SBM public 2010 43.031
SBM public 2011 57.804
SBM public 2012 11.37
SBM public 2013 10.824
SBM public 2014 3.607
SBM public 2015 6.351
SBM public 2016 4.258
SBP public 1997 0.244
SBP public 1998 0.285
SBP public 1999 0.296
SBP public 2000 18.582
SBP public 2001 15.707
SBP public 2002 10.753
SBP public 2003 9.105
SBP public 2004 8.512
SBP public 2005 42.495
SBP public 2006 35.541
SBP public 2007 68.201
SBP public 2008 297.793
SBP public 2009 297.504
SBP public 2010 118.894
SBP public 2011 60.251
SBP public 2012 34.844
SBP public 2013 21.013
SBP public 2014 4.743
SBP public 2015 3.211
SBP public 2016 -1.872
SBS public 1989 0.081
SBS public 1997 0.249
SBS public 1998 0.34
SBS public 1999 0.293
SBS public 2000 6.605
SBS public 2001 0.228
SBS public 2002 10.284
SBS public 2003 11.237
SBS public 2004 5.376
SBS public 2005 3.275
SBS public 2006 3.265
SBS public 2007 8.814
SBS public 2008 2.704
SBT public 1996 0.155
SBT public 1997 0.138
SBT public 1998 0.198
SBT public 1999 0.181
SBT public 2000 9.102
SBT public 2001 25.864
SBT public 2002 63.596
SBT public 2003 30.811
SBT public 2004 17.513
SBT public 2005 43.985
SBT public 2006 44.115
SBT public 2007 44.128
SBT public 2008 33.247
SBT public 2009 10.316
SBT public 2010 10.858
SBT public 2011 13.591
SBT public 2012 21.53
SBT public 2013 23.691
SBT public 2014 2.751
SBT public 2015 3.267
SBT public 2016 3.097
UCO public 1992 1.732
UCO public 1993 -0.199
UCO public 1994 -0.283
UCO public 1995 1.577
UCO public 1996 0.898
UCO public 1997 0.315
UCO public 1998 1.045
UCO public 1999 -3.466
UCO public 2000 10.865
UCO public 2001 14.886
UCO public 2002 5.592
UCO public 2003 5.581
UCO public 2004 5.239
UCO public 2005 5.594
UCO public 2006 7.031
UCO public 2007 6.194
UCO public 2008 5.998
UCO public 2009 5.789
UCO public 2010 5.401
UCO public 2011 5.675
UCO public 2012 5.661
UCO public 2013 7.189
UCO public 2014 5.735
UCO public 2015 6.384
UCO public 2016 -4.225
UCO public 2017 -3.928
UCO public 2018 -4.334
UCO public 2019 -4.309
UCO public 2020 -3.963
UBI public 1990 0.136
UBI public 1991 0.122
UBI public 1992 0.175
UBI public 1993 0.179
UBI public 1994 0.288
UBI public 1995 0.266
UBI public 1996 0.245
UBI public 1997 0.283
UBI public 1998 0.304
UBI public 1999 0.28
UBI public 2000 4.936
UBI public 2001 10.405
UBI public 2002 26.413
UBI public 2003 10.074
UBI public 2004 8.882
UBI public 2005 9.911
UBI public 2006 15.493
UBI public 2007 12.869
UBI public 2008 8.639
UBI public 2009 8.568
UBI public 2010 8.7
UBI public 2011 10.532
UBI public 2012 18.248
UBI public 2013 18.265
UBI public 2014 39.491
UBI public 2015 25.514
UBI public 2016 7.635
UBI public 2017 1.747
UBI public 2018 -2.767
UBI public 2019 -2.061
UBI public 2020 -1.905
UNI public 1993 0.52
UNI public 1994 -0.716
UNI public 1995 0.086
UNI public 1996 0.118
UNI public 1997 0.451
UNI public 1998 2.538
UNI public 1999 3.414
UNI public 2000 10.476
UNI public 2001 3.761
UNI public 2002 9.056
UNI public 2003 5.851
UNI public 2004 5.986
UNI public 2005 6.404
UNI public 2006 8.118
UNI public 2007 7.536
UNI public 2008 7.831
UNI public 2009 21.291
UNI public 2010 11.678
UNI public 2011 7.987
UNI public 2012 7.689
UNI public 2013 15.818
UNI public 2014 -3.52
UNI public 2015 23.795
UNI public 2016 -1.708
UNI public 2017 9.686
UNI public 2018 -3.482
UNI public 2019 -3.773
UWB private 1992 0.077
UWB private 1993 0.098
UWB private 1994 0.112
UWB private 1995 0.108
UWB private 1996 0.31
UWB private 1997 0.287
UWB private 1998 4.328
UWB private 1999 4.994
UWB private 2000 4.225
UWB private 2001 0.192
UWB private 2002 34.585
UWB private 2003 861.706
UWB private 2004 36.576
UWB private 2005 -1.808
VIJAYA public 1994 0.153
VIJAYA public 1995 0.199
VIJAYA public 1996 -0.038
VIJAYA public 1997 0.227
VIJAYA public 1998 0.209
VIJAYA public 1999 3.272
VIJAYA public 2000 5.701
VIJAYA public 2001 14.807
VIJAYA public 2002 23.077
VIJAYA public 2003 11.65
VIJAYA public 2004 7.028
VIJAYA public 2005 8.761
VIJAYA public 2006 9.012
VIJAYA public 2007 18.465
VIJAYA public 2008 59.697
VIJAYA public 2009 26.67
VIJAYA public 2010 51.528
VIJAYA public 2011 119.626
VIJAYA public 2012 93.305
VIJAYA public 2013 26.568
VIJAYA public 2014 4.966
VIJAYA public 2015 4.467
VIJAYA public 2016 3.446
VIJAYA public 2017 11.561
VIJAYA public 2018 8.552
YES private 2005 -0.356
YES private 2006 8.103
YES private 2007 14.861
YES private 2008 12.689
YES private 2009 11.83
YES private 2010 9.763
YES private 2011 11.931
YES private 2012 12.079
YES private 2013 12.043
YES private 2014 11.51
YES private 2015 10.478
YES private 2016 9.836
YES private 2017 9.699
YES private 2018 9.831
YES private 2019 4.347
YES private 2020 -3.193
2

Hello @zeeshan0112 ,
there is no need to list the whole dataset. A few lines make the structure clear.
An answer to your question could be

library(dplyr)
#> 
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#> 
#>     filter, lag
#> The following objects are masked from 'package:base':
#> 
#>     intersect, setdiff, setequal, union
library(ggplot2)
library(lubridate)
#> 
#> Attaching package: 'lubridate'
#> The following objects are masked from 'package:base':
#> 
#>     date, intersect, setdiff, union

set.seed(2021)
df = unique(data.frame(
  stringsAsFactors = F,
  bank = sample(c("ALD", "BOI", "BOM", "ZXG") , 100 , replace = TRUE),
  year = sample(1991:2000, 100, replace = TRUE)
)) %>%
  mutate(z_score = runif(nrow(.), 0, 1),
         year = parse_date_time(as.character(year),"%y"))

ggplot(df, aes(x=year, y=z_score,color=bank)) +
geom_point(size=5, alpha=0.9) +
geom_hline(yintercept = 0,size=1.0,linetype=5)+
ggtitle("z-score for banks from 1991 to 2000")+
xlab("year") +
ylab("z score") 

Created on 2021-07-24 by the reprex package (v2.0.0)

It produces the following plot:

image

1 Like
4

Thanks a lot for a swift reply.

5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.