Python: import selected rows of dataframe. My data is in xlsx format -


hi beginner @ machine learning in python environment , want import first 30-40 rows of dataframe has 30.000 rows development.thank

you can use pandas.read_csv 'nrows' parameter, this:

pd.read_csv(myfilepath, nrows=30)

nrows : int, default none
number of rows of file read. useful reading pieces of large files

full documentation can found here

if want after read file:

dataframe.head(n=30)

Comments

Post a Comment

Popular posts from this blog

4x4 Matrix in Python -

im trying code 4x4 matrix in python random integers 1-4. thats easy enough problem want each row , each column 1 time uses of each digit 1-4 example 1 2 3 4 2 3 4 1 3 4 1 2 4 1 2 3 my code 33% of time in loop there happens somthing this 2 1 4 3 3 4 2 1 1 3 x <-------- because of programm cant contiune , end in infinity loop helb how can out? code below """ programm playing game skyline """ random import randrange row1 = [] row2 = [] row3 = [] row4 = [] allrows = [row1, row2, row3, row4] column1 = [] column2 = [] column3 = [] column4 = [] allcolumns = [column1, column2, column3, column4] def board(): in range(4): j = 0 while len(allrows[i]) != 4: x = randrange(1,5) print(i, j) if x not in allrows[i] , x not in allcolumns[j]: allrows[i].append(x) allcolumns[j].append(x) j += 1 else: continue boa...
Read more

python - PyInstaller UAC not working in onefile mode -

hello everybody. i have small python project , want make single executable file . using... windows 7 python 3.4 pyinstaller 3.2.1 my pyinstaller command is, pyinstaller -y -w -f -n output_file_name --uac-admin --clean source_file.py this command works properly. single output file not ask admin rights when executed. , there's no shield mark on executable file icon. when remove -f option (equivalent --onefile), output executable file has shield mark on icon , ask me admin rights. not want. want single executable file. i found manifest file (output_file_name.exe.manifest) in dist\output_file_name folder. did... pyinstaller -y -w -f -n output_file_name --manifest output_file_name.exe.manifest --uac-admin --clean source_file.py but command doesn't work. single executable file still not ask admin rights. i have removed pyinstaller , installed recent development version. pip install git+https://github.com/pyinstaller/pyinstaller.git@develop but result...
Read more

javascript - Building and updating array objects -

i'm working on simple registration system displays number of seats available in particular workshop. it's built in google apps script runs javascript syntax. i build array of class objects user when log in. 1 of object keys seats , shows available number of spots left in workshop. that, compare master list of classes max number of registrants current registration list. class object [{ date: 4/10/2017, title: "workshop 1", desc: "a string description 1", seats: "" }] google sheets table | date | title | description | seats | | |-----------|------------|----------------------------|-------|---| | 4/10/2017 | workshop 1 | string description 1 | 20 | | | 5/10/2017 | workshop 2 | string description 2 | 25 | | current registrations | user | class0 | class1 | |-------|-----------|-----------| | user1 | 4/10/2017 | | | user2 | 4/10/2017 | 5/10/2017 | | | | ...
Read more