[SPARK-31964][PYTHON] Use Pandas is_categorical on Arrow category type conversion
[SPARK-31964][PYTHON] Use Pandas is_categorical on Arrow category type conversion

### What changes were proposed in this pull request?

When using pyarrow to convert a Pandas categorical column, use `is_categorical` instead of trying to import `CategoricalDtype`

### Why are the changes needed?

The import for `CategoricalDtype` had changed from Pandas 0.23 to 1.0 and pyspark currently tries both locations. Using `is_categorical` is a more stable API.

### Does this PR introduce _any_ user-facing change?

No

### How was this patch tested?

Existing tests

Closes #28793 from BryanCutler/arrow-use-is_categorical-SPARK-31964.

Authored-by: Bryan Cutler <060dd14c05a8ffa8f201883ef57d0676b7c9c04a@gmail.com>
Signed-off-by: HyukjinKwon <2680965ad5aae29275c8fb10150cb10f5554e78b@apache.org>

JoshRosen/spark,witgo/spark,apache/spark,ptkool/spark,gengliangwang/spark,dongjoon-hyun/spark,wangyum/spark,chuckchen/spark,ueshin/apache-spark,srowen/spark,spark-test/spark,mahak/spark,zzcclp/spark,apache/spark,shaneknapp/spark,milliman/spark,dbtsai/spark,WeichenXu123/spark,mahak/spark,holdenk/spark,maropu/spark,nchammas/spark,taroplus/spark,HyukjinKwon/spark,srowen/spark,JoshRosen/spark,shaneknapp/spark,holdenk/spark,taroplus/spark,wangyum/spark,dongjoon-hyun/spark,apache/spark,dongjoon-hyun/spark,mahak/spark,milliman/spark,WeichenXu123/spark,srowen/spark,mahak/spark,HyukjinKwon/spark,chuckchen/spark,maropu/spark,jiangxb1987/spark,rednaxelafx/apache-spark,wangmiao1981/spark,ueshin/apache-spark,wzhfy/spark,jiangxb1987/spark,ConeyLiu/spark,cloud-fan/spark,WeichenXu123/spark,mahak/spark,JoshRosen/spark,BryanCutler/spark,ptkool/spark,milliman/spark,milliman/spark,cloud-fan/spark,wangyum/spark,BryanCutler/spark,BryanCutler/spark,ConeyLiu/spark,ptkool/spark,BryanCutler/spark,hvanhovell/spark,hvanhovell/spark,dbtsai/spark,srowen/spark,dongjoon-hyun/spark,zero323/spark,jiangxb1987/spark,taroplus/spark,xuanyuanking/spark,taroplus/spark,jiangxb1987/spark,nchammas/spark,shuangshuangwang/spark,nchammas/spark,hvanhovell/spark,zero323/spark,maropu/spark,cloud-fan/spark,vinodkc/spark,xuanyuanking/spark,spark-test/spark,vinodkc/spark,rednaxelafx/apache-spark,witgo/spark,wangmiao1981/spark,wzhfy/spark,ptkool/spark,witgo/spark,zero323/spark,chuckchen/spark,dbtsai/spark,JoshRosen/spark,rednaxelafx/apache-spark,hvanhovell/spark,vinodkc/spark,wangyum/spark,ConeyLiu/spark,hvanhovell/spark,gengliangwang/spark,dbtsai/spark,milliman/spark,maropu/spark,wangmiao1981/spark,ConeyLiu/spark,xuanyuanking/spark,milliman/spark,shuangshuangwang/spark,zzcclp/spark,maropu/spark,wzhfy/spark,ueshin/apache-spark,xuanyuanking/spark,zzcclp/spark,zero323/spark,WeichenXu123/spark,wangmiao1981/spark,chuckchen/spark,hvanhovell/spark,wangmiao1981/spark,gengliangwang/spark,zzcclp/spark,wangyum/spark,gengliangwang/spark,mahak/spark,shuangshuangwang/spark,WeichenXu123/spark,spark-test/spark,zero323/spark,taroplus/spark,ueshin/apache-spark,dbtsai/spark,vinodkc/spark,ConeyLiu/spark,xuanyuanking/spark,shaneknapp/spark,ptkool/spark,zzcclp/spark,hvanhovell/spark,JoshRosen/spark,zero323/spark,wzhfy/spark,vinodkc/spark,nchammas/spark,dongjoon-hyun/spark,HyukjinKwon/spark,rednaxelafx/apache-spark,wzhfy/spark,holdenk/spark,HyukjinKwon/spark,apache/spark,jiangxb1987/spark,holdenk/spark,ptkool/spark,JoshRosen/spark,cloud-fan/spark,chuckchen/spark,shaneknapp/spark,vinodkc/spark,apache/spark,HyukjinKwon/spark,apache/spark,dongjoon-hyun/spark,srowen/spark,holdenk/spark,wangmiao1981/spark,xuanyuanking/spark,spark-test/spark,milliman/spark,gengliangwang/spark,ptkool/spark,HyukjinKwon/spark,rednaxelafx/apache-spark,wangmiao1981/spark,cloud-fan/spark,ueshin/apache-spark,nchammas/spark,taroplus/spark,apache/spark,wzhfy/spark,maropu/spark,zero323/spark,wzhfy/spark,maropu/spark,gengliangwang/spark,shaneknapp/spark,rednaxelafx/apache-spark,ueshin/apache-spark,chuckchen/spark,wangyum/spark,cloud-fan/spark,nchammas/spark,jiangxb1987/spark,jiangxb1987/spark,shuangshuangwang/spark,JoshRosen/spark,BryanCutler/spark,wangyum/spark,zzcclp/spark,holdenk/spark,witgo/spark,nchammas/spark,gengliangwang/spark,rednaxelafx/apache-spark,cloud-fan/spark,WeichenXu123/spark,vinodkc/spark,mahak/spark,spark-test/spark,ueshin/apache-spark,zzcclp/spark,witgo/spark,chuckchen/spark,spark-test/spark,holdenk/spark,shaneknapp/spark,shaneknapp/spark,HyukjinKwon/spark,BryanCutler/spark,dbtsai/spark,shuangshuangwang/spark,srowen/spark,BryanCutler/spark,shuangshuangwang/spark,ConeyLiu/spark,WeichenXu123/spark,spark-test/spark,dongjoon-hyun/spark,xuanyuanking/spark,witgo/spark,dbtsai/spark,shuangshuangwang/spark,witgo/spark,srowen/spark,taroplus/spark,ConeyLiu/spark