Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
Head First Data Analysis Head First Data Analysis
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 1
    • Issues 1
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • examples
  • Head First Data AnalysisHead First Data Analysis
  • Issues
  • #1

Closed
Open
Created Sep 29, 2017 by zhouwenwen@duohappy

there is mistake in historical_sales_data.xls

there is a 'error' blank in the column name 'Total'. if I use pandas to handle this file, the result is confusing.

Actually, the column name in the Excel file should be 'Total' without the 'error' blank.

import pandas
df = pandas.read_excel('./historical_sales_data.xls')
print(df['Fish']) # this is ok
print(df['Total'])  # error!
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking

© 2021 O’Reilly Media, Inc. All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. Terms of Service • Privacy Policy • Editorial Independence