Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question
Write a python program that read any xls file and return 3 things 1. y is a 1-dimentional numpy array containing the last column of the spreadsheet. 2. X is a 2-dimensional numpy array that contains the data in the other columns and the first column is filled with 1s. 3. labels is a list of strings from the header in the spreadsheet.
Expert Solution
Check Mark
Step 1

Algorithm:

  1. Start
  2. Read the content of xls file and store it in df
  3. Extract the last column of df and store it in y i.e set y=df[df.columns[-1]].to_numpy()
  4. Extract all other columns and store them in x by adding a column of 1's as the first column i.e set x=np.c_[np.ones(len(y)),df.iloc[:,:-1].to_numpy()]
  5. Print y,x
  6. Get the headers of xls file and store it in labels i.e set labels = list(df.columns)
  7. Print labels
  8. Stop
Knowledge Booster
Background pattern image
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
    Recommended textbooks for you
    Text book image
    Database System Concepts
    Computer Science
    ISBN:9780078022159
    Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
    Publisher:McGraw-Hill Education
    Text book image
    Starting Out with Python (4th Edition)
    Computer Science
    ISBN:9780134444321
    Author:Tony Gaddis
    Publisher:PEARSON
    Text book image
    Digital Fundamentals (11th Edition)
    Computer Science
    ISBN:9780132737968
    Author:Thomas L. Floyd
    Publisher:PEARSON
    Text book image
    C How to Program (8th Edition)
    Computer Science
    ISBN:9780133976892
    Author:Paul J. Deitel, Harvey Deitel
    Publisher:PEARSON
    Text book image
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781337627900
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Text book image
    Programmable Logic Controllers
    Computer Science
    ISBN:9780073373843
    Author:Frank D. Petruzella
    Publisher:McGraw-Hill Education