geekcomputers / geekcomputers/Python
Csv file and xlrd
Open
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 35.4k
- Forks
- 12.9k
- Avg merge
- 2h 37m
- Merged PRs (30d)
- 1
Description
import all required library
Import xlrd
Import csv
Import pandas csv
open workbook by sheet index
optional_sheet_by_index()
Sheet=xlrd.open_workbook("Test.xlsx").sheet_by_index(0)
writen object is created
Col= csv.writen(open("Tcsv",'w',newline=" " ))
writing the data into csv file for row in range(sheet.nrows):
row by row write
operation is perform
Col.writerow (sheet.row_valued(row))
read csv file and convert
into a dataframe object
df=pd.Data frame(pd.read_csv("Tcsv)))
show the data frame df
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No repository file, test, or entry point is identified. First clarify whether this is meant to add a runnable CSV/XLSX conversion example or fix the shown code; done should be defined as a working, tested example in a named project location.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- pandas, python
- Domain
- data
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 15/100