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]()