Using python to extract out data from excel csv file [closed]

by

A good recommendation I can make for reading/manipulating csv data is pandas. For example reading data using pandas is as simple as:

import pandas as pd
df = pd.read_csv( "my/path/to/database1.csv" )

The result is a dataframe. A tabular representation of your data which can be manipulated in any number of ways. Writing to a csv is also another one liner. You can use the following:

df.to_csv( "my/path/to/output.csv" )

There are other methods available for working with excel data, such as pd.read_excel and df.to_excel. More available here. Hope this helps.

More Related Contents:

  1. How do I get the path and name of the file that is currently executing?
  2. How to execute Python scripts in Windows?
  3. Python recursive folder read
  4. How can I sandbox Python in pure Python?
  5. How to make a Python script run like a service or daemon in Linux
  6. Driving Excel from Python in Windows
  7. Get name of current script in Python
  8. Why the Global Interpreter Lock?
  9. How do I abort the execution of a Python script? [duplicate]
  10. Loading external script with jinja2 template directive
  11. Purpose of #!/usr/bin/python3 shebang
  12. Checking if a website is up via Python
  13. Batch equivalent of “source” on Windows: how to run a Python script from a virtualenv
  14. QtDesigner changes will be lost after redesign User Interface
  15. Python OpenCV streaming from camera – multithreading, timestamps
  16. Currency formatting in Python
  17. pip install access denied on Windows
  18. Python Multiprocessing: Handling Child Errors in Parent
  19. rreplace – How to replace the last occurrence of an expression in a string?
  20. Monkey patching a class in another module in Python
  21. Finding the user’s “My Documents” path
  22. How do i use subprocesses to force python to release memory?
  23. Access request in django custom template tags
  24. How can I get all the plain text from a website with Scrapy?
  25. Is it possible to add a string as a legend item in matplotlib
  26. How to replicate array to specific length array
  27. Cannot get minor grid lines to appear in matplotlib figure
  28. Filling Many2many field (odoo 8)
  29. Model help using Scikit-learn when using GridSearch
  30. Change the file extension for files in a folder?

Leave a Comment