in reply to Learning to use Perl

This has the school room aroma of homework to it. If so, please let us know so we can tune our answers to best help you learn.

What specifically is your question? You list a bunch of things that may be stuff you have been asked to achieve and you have some sample code that may or may not do some of that stuff, but you don't say where things are failing or what you are specifically having trouble with.

Optimising for fewest key strokes only makes sense transmitting to Pluto or beyond

Replies are listed 'Best First'.
Re^2: Learning to use Perl
by haukex (Archbishop) on Nov 09, 2020 at 20:42 UTC
    This has the school room aroma of homework to it.

    Note in the OP:

    'C:\Users\fefe\Documents\CS 260\Big_Data_Servers_Table'

    Google "Your first task at Big Data Datacenter is to show some simple proof of concept types of activities." (with quotes) to find the exact problem statement posted above on various "homework help" sites. A Big_Data_Servers_Table.xlsx can be downloaded from http://class.coloradotech.edu/CbFileShareCommon/ctu/CSS260/Assignment_Assets/Big_Data_Servers_Table.xlsx.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom