Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Editing spreadsheet/csv
#4
What do you see if you run this:
import pandas as pd

df = pd.read_excel("spreadshet_filename.xlsx").head(10)  # Change to name of your spreadsheet file.
print(df)
Post results if they don't contain anything sensitive.
Reply


Messages In This Thread
Editing spreadsheet/csv - by BSDevo - Aug-31-2023, 04:15 PM
RE: Editing spreadsheet/csv - by deanhystad - Aug-31-2023, 05:13 PM
RE: Editing spreadsheet/csv - by BSDevo - Aug-31-2023, 06:31 PM
RE: Editing spreadsheet/csv - by deanhystad - Aug-31-2023, 06:48 PM
RE: Editing spreadsheet/csv - by BSDevo - Aug-31-2023, 06:59 PM
RE: Editing spreadsheet/csv - by deanhystad - Aug-31-2023, 08:20 PM
RE: Editing spreadsheet/csv - by BSDevo - Sep-01-2023, 05:47 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Returning Column and Row Data From Spreadsheet knight2000 0 499 Oct-22-2023, 07:07 AM
Last Post: knight2000
  Looking to automate updating a spreadsheet with image from email cubangt 2 1,054 Feb-14-2023, 03:43 PM
Last Post: cubangt
  Import XML file directly into Excel spreadsheet demdej 0 910 Jan-24-2023, 02:48 PM
Last Post: demdej
  Need help editing a PDF omar 4 1,164 Oct-22-2022, 08:52 PM
Last Post: Larz60+
  updating Google spreadsheet with gspread mgallotti 0 1,190 Sep-30-2022, 11:26 PM
Last Post: mgallotti
  Modify LibreOffice's ods spreadsheet Pavel_47 0 1,246 Jul-13-2022, 11:28 AM
Last Post: Pavel_47
  Python create a spreadsheet with column and row header ouruslife 4 1,779 Jul-09-2022, 11:01 AM
Last Post: Pedroski55
  Searching for URLs and printing the corresponding row from an Excel spreadsheet johnbernard 0 1,317 Aug-20-2021, 06:43 PM
Last Post: johnbernard
  "Switch-to-spreadsheet" entry. Feasible in Python? whatspython 2 2,073 Sep-30-2020, 01:12 PM
Last Post: buran
  PYTHON - GOOGLE... create new spreadsheet? danclark81 3 2,767 Feb-02-2020, 08:57 PM
Last Post: danclark81

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020