Python, extract dataframe via column names and extract rows via iloc

import uuid
import pandas as pd
import numpy as np
from datetime import datetime

#show all rows when print
pd.set_option('display.max_rows',None)
book_list=[]
arr=range(1,1000001)
for a in arr:
    book_list.append({
        "Id":a,
        "Name":f'Name_{a}',
        "ISBN":f'ISBN_{uuid.uuid4().hex}_{a}',
        "FName":f'FName_{a}',
        "Author":f'Author_{a}',
        "MName":f'Manem_{a}',
        "Content":f'Content_{a}',
        "LName":f'LName_{a}',
        "Summary":f'Summary_{a}',        
        'SurName':f'SurName_{a}',
        "Title":f'Title_{a}',
        'FTitle':f'FTitle_{a}',
        'LTitle':f'LTitle_{a}',
        'GiveName':f'GivenName_{a}'
    })

df=pd.DataFrame(book_list)
csv_file=f'CSV_{datetime.now().strftime('%Y%m%d%H%M%S%f')}.csv'
df.to_csv(csv_file,index=False,encoding='utf-8')
df=pd.read_csv(csv_file)

name_columns=(col for col in df.columns if 'Name' in col)
name_df=df[name_columns]
print("\nRow between 10 and 20 with name columns:")
print(name_df.iloc[9:19])
 
title_columns=(col for col in df.columns if 'Title' in col)
title_df=df[title_columns]
print("\nRow between 100 and 120 with Title columns:")
print(title_df.iloc[99:119])

 

 

 

 

 

 

 

image

 

 

 

 

 

image

 

 

 

import uuid
import pandas as pd
import numpy as np
from datetime import datetime

#show all rows when print
pd.set_option('display.max_rows',None)
book_list=[]
arr=range(1,1000001)
for a in arr:
    book_list.append({
        'Id':a,
        'Name':f'Name_{a}',
        'ISBN':f'ISBN_{uuid.uuid4().hex}_{a}',
        'FName':f'FName_{a}',
        'Author':f'Author_{a}',
        'MName':f'Manem_{a}',
        'Content':f'Content_{a}',
        'LName':f'LName_{a}',
        'Summary':f'Summary_{a}',        
        'SurName':f'SurName_{a}',
        'Title':f'Title_{a}',
        'Title2':f'Title2_{a}',
        'Title3':f'Title3_{a}',
        'Title4':f'Title4_{a}',
        'FTitle':f'FTitle_{a}',
        'LTitle':f'LTitle_{a}',
        'Topic':f'Topic_{a}',
        'Topic2':f'Topic2_{a}',
        'Topic3':f'Topic3_{a}',
        'Topic4':f'Topic4_{a}',
        'Content2':f'Content2_{a}',
        'Content3':f'Content3_{a}',
        'Content4':f'Content4_{a}',
        'GiveName':f'GivenName_{a}'
    })

df=pd.DataFrame(book_list)
csv_file=f'CSV_{datetime.now().strftime('%Y%m%d%H%M%S%f')}.csv'
df.to_csv(csv_file,index=False,encoding='utf-8')
df=pd.read_csv(csv_file)

name_columns_list=list(col for col in df.columns if 'Name' in col)
if 'Id' in df.columns and 'Id' not in name_columns_list:
    name_columns_list.insert(0,'Id')

name_df=df[name_columns_list]
print('\nRow between 10 and 20 with name columns:')
print(name_df.iloc[9:19])

title_columns_list=list(col for col in df.columns if 'Title' in col)
if 'Id' in df.columns and 'Id' not in title_columns_list:
    title_columns_list.insert(0,'Id')

title_df=df[title_columns_list]
print(title_df.iloc[10:20])
 
# title_columns=(col for col in df.columns if 'Title' in col)
# title_df=df[title_columns]
# print('\nRow between 100 and 120 with Title columns:')
# print(title_df.iloc[99:119])

 

 

 

image

 

posted @ 2025-12-12 21:06  FredGrit  阅读(1)  评论(0)    收藏  举报