geekcomputers / geekcomputers/Python
Cvc file in python
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 or test is identified. Start by reviewing the provided xlrd, csv, and pandas example and reproduce its workbook-to-CSV flow using Test.xlsx. Done means the intended sheet data is written to Tcsv and can be read as a pandas dataframe without errors.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- data
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100