PythonによるExcelファイルの一括操作の説明

package cc.testscaletype;

import android.app.Activity;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;
import android.os.Bundle;
import android.widget.ImageView;
import android.widget.ImageView.ScaleType;
ScaleType; /**
 * Demo description:
 * 
 * Explain the properties of ImageView such as CENTER_CROP, CENTER_INSIDE, FIT_CENTER, etc.
 * 
 * 
 * 
 * Demo description:
 * 
 * 1 Prepare three images of different sizes
 * logo----->360*360
 * dogs----->1024*682
 * bdog----->1920*1080
 *   
 * 2 Set the size of the ImageView to 750px in the layout file
 * 
 * 3 For comparison and understanding, test each property of the ImageView in turn
 * 
 * 
 * 
 * Original author:
 * Valley's little brother
 * http://blog.csdn.net/lfdfhl
 *
 */

public class MainActivity extends Activity {
    private ImageView mImageView;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        mImageView = (ImageView) findViewById(R.id.iamgeView);
        int logo_id=R.drawable.logo;
        int dogs_id=R.drawable.dogs;
        int bdog_id=R.drawable.bdog;


        //testCenter(logo_id);
        //testCenter(dogs_id);
        //testCenter(bdog_id);


        //testCenterCrop(logo_id);
        //testCenterCrop(dogs_id);
        //testCenterCrop(bdog_id);


        //testCenterInside(logo_id);
        //testCenterInside(dogs_id);
        //testCenterInside(bdog_id);


        testFitCenter(logo_id);
        //testFitCenter(dogs_id);
        //testFitCenter(bdog_id);


        //testFitEnd(logo_id);
        //testFitEnd(dogs_id);
        //testFitEnd(bdog_id);


        //testFitStart(logo_id);
        //testFitStart(dogs_id);
        //testFitStart(bdog_id);


        //testFitXY(logo_id);
        //testFitXY(dogs_id);
        //testFitXY(bdog_id);
    }

    /**
     * testCENTER attribute
     * 
     * Display the image at the center of the ImageView, without performing any scaling
     * 
     * 1.1 If the width and height of the image are smaller than the width and height of the ImageView control, the image is displayed in the middle of the ImageView
     * 1.2 If the image width or height is greater than the width or height of the ImageView control, the image is not displayed in its entirety
     * If the width or height of the image is larger than the width or height of the ImageView control, the image will not be displayed in its entirety.    
     * i.e. under this property:
     * If the width and height of the image are smaller than the width and height of the image, then the image will be displayed in its original size in the middle of the ImageView.
     * If the width or height of the image is larger than the size of the ImageView, the image will not be displayed in its entirety.
     * 
     */
    private void testCenter(int resourceID) {
        Bitmap bitmap = BitmapFactory.decodeResource(getResources(),resourceID);
        System.out.println("---> width=" + bitmap.getWidth() + " ,height=" + bitmap.getHeight());
        mImageView.setScaleType(ScaleType.CENTER);
        mImageView.setImageResource(resourceID);
    }

    /**
     * Test the CENTER_CROP property
     * 
     * Place the image at the center of the ImageView, and then scale the image equally
     * 
     * Official documentation describes.
     * Scale the image uniformly (maintain the image's aspect ratio) so that 
     * both dimensions (width and height) of the image will be equal to or larger 
     * than the corresponding dimension of the view (minus padding). 
     * This text is worth appreciating.
     * In a nutshell.
     * Scaling the image equally so that both dimensions (width and height) of the image will be equal to or larger than the corresponding dimension of the view (minus padding).
     * 
     * 1.1 If the width and height of the image are smaller than the width and height of the ImageView control, then scale the image equally until it fills the ImageView.
     * Of course, in this case, the equal scaling may cause the image to be displayed in the X or Y direction incomplete.
     * 1.2 If the width or height of the image is smaller than the width or height of the ImageView control, then the image is scaled up until it fills the ImageView.
     * For example, if the ImageView is 750*750 and the image is 600*800, the image will be scaled up until the width of the image becomes
     * But this will cause the height of the image to be greater than the height of the ImageView, so the vertical direction of the image will not be fully displayed and will be cropped.
     * 1.3 If the width and height of the image are greater than the width and height of the ImageView control
     * In this case, the image is scaled down equally, and the scaling stops when any value in the width and height of the image is equal to the corresponding width and height of the control.
     * In this case it is likely to cause: incomplete display of the image
     * 
     * So the distinguishing feature of the CENTER_CROP property:
     * The image will be spread over the whole ImageView, but the image may be displayed incompletely
     * 
     */
    private void testCenterCrop(int resourceID) {
        Bitmap bitmap = BitmapFactory.decodeResource(getResources(),resourceID);
        System.out.println("---> width=" + bitmap.getWidth() + " ,height=" + bitmap.getHeight());
        mImageView.setScaleType(ScaleType.CENTER_CROP);
        mImageView.setImageResource(resourceID);
    }


    /**
     * Test the CENTER_INSIDE property
     * 
     * Place the image at the center of the ImageView, and then scale the image equally
     * 
     * Official documentation:
     * Scale the image uniformly (maintain the image's aspect ratio) so that 
     * both dimensions (width and height) of the image will be equal to or less 
     * than the corresponding dimension of the view (minus padding). 
     * 
     * In a nutshell.
     * scales the image equally so that both dimensions (width and height) of the image will be equal to or less * than the corresponding dimension of the view (minus padding).
     * * In short 
     * 1.1 If both the width and height of the image are smaller than the width and height of the ImageView control, the image is placed in the middle of the ImageView.
     * In this case, the background color of the ImageView is visible around the image
     * 1.2 If the width or height of the image is greater than the width or height of the ImageView control, the image is scaled down until the ImageView can display the image in its entirety.
     * In this case, the background color of the ImageView is visible above and below or to the left and right of the image.
     * 1.3 If the width and height of the image are greater than the width and height of the ImageView control
     * In this case, the image is scaled down so that neither the width nor the height of the image is greater than the width and height of the control.
     * So, it is also easy to cause the background color of the ImageView to be visible above and below or to the left and right of the image
     * 
     * So far, you can see the characteristics of the CENTER_INSIDE property
     * 1 Will always display the entire image completely
     * 2 It is likely to cause the ImageView control to be left white, i.e. revealing the background color
     * 
     * 
     * The difference between CENTER_CROP and CENTER_INSIDE is obvious at this point.
     * 1 CENTER_CROP requires the width and height of the image to be no smaller than the control width and height
     * 2 CENTER_INSIDE requires the width and height of the image to be no larger than the control's width and height.
     * 
     */
    private void testCenterInside(int resourceID) {
        Bitmap bitmap = BitmapFactory.decodeResource(getResources(),resourceID);
        System.out.println("---> width=" + bitmap.getWidth() + " ,height=" + bitmap.getHeight());
        mImageView.setScaleType(ScaleType.CENTER_INSIDE);
        mImageView.setImageResource(resourceID);
    }

    /**
     * Test the FIT_CENTER property
     * 
     * Place the image at the center of the ImageView, and then scale the image equally
     * 
     * Official documentation.
     * Scale the image using CENTER.
     * CENTER: 
     * Compute a scale that will maintain the original src aspect ratio, 
     * The result is centered inside dst. 
     * At least one axis (X or Y) will fit exactly. The result is centered inside dst.
     *The result is centered inside dst. 
     The result is centered inside dst. * After understanding CENTER_CROP and CENTER_INSIDE, it's easier to look at FIT_CENTER
     * 
     * Place the image at the center of the ImageView and scale it equally to show the image in its entirety.
     * 
     * 
     * 
     * 1.1 If the width and height of the image are smaller than the width and height of the ImageView control, then scale the image equally
     * until any of the values in the width and height of the image is equal to the width or height of the control
     * In this case, the background color of the ImageView is visible above and below or to the left and right of the image.
     *     
     *    
     * 1.2 If the width and height of the image are greater than the width and height of the ImageView control, then scale the image down equally
     * until any of the values in the image's width and height are equal to the control's width or height
     * So, this also easily results in the background color of the ImageView visible above and below or to the left and right of the image
     *     
     * 1.3 If the width or height of the image is greater than the width or height of the ImageView control
     * Should I perform a zoom in or a zoom out at this point? Or shrink it?
     * Actually, there is a principle at this point: display the image in its entirety.
     * As the documentation says: ensure that src fits entirely inside dst
     * So, at this point, the image is scaled until neither the width nor the height of the image is larger than the width and height of the control
     *    
     * 
     * So, the picture is displayed in its entirety when using FIT_CENTER, and it has one remarkable feature.
     * It makes at least one value in the picture's width and height exactly equal to the control's width or height.
     * This is also the main difference between it and the CENTER_INSIDE property
     * 
     * 
     * 
     */
    private void testFitCenter(int resourceID) {
        Bitmap bitmap = BitmapFactory.decodeResource(getResources(),resourceID);
        System.out.println("---> width=" + bitmap.getWidth() + " ,height=" + bitmap.getHeight());
        mImageView.setScaleType(ScaleType.FIT_CENTER);
        mImageView.setImageResource(resourceID);
    }


    /**
     * Test the FIT_END property
     * 
     * FIT_END is very similar to the FIT_CENTER property
     * The difference is that FIT_END ends up placing the scaled image in the lower right corner of the ImageView control
     */
    private void testFitEnd(int resourceID) {
        Bitmap bitmap = BitmapFactory.decodeResource(getResources(),resourceID);
        System.out.println("---> width=" + bitmap.getWidth() + " ,height=" + bitmap.ge

import os
os.listdir('D:/Data-Science/share/data/test')

os.rename('D:/Data-Science/share/data/test/test_old.xlsx'
          ,'D:/Data-Science/share/data/test/test_new.xlsx')

os.mkdir('D:/Data-Science/share/data/test11')

os.removedirs('D:/Data-Science/share/data/test11')

os.remove('D:/Data-Science/share/data/test/test_new.xlsx')

import pandas as pd

#Get all the names of the files under the folder
name_list = os.listdir('D:/Data-Science/share/data/test')

#for loop traversal to read
for i in name_list:
    df = pd.read_excel(r'D:/Data-Science/share/data/test/' + i)
    print('{}Reading done!' .format(i))

import pandas as pd

#Get all the names of the files under the folder
name_list = os.listdir('D:/Data-Science/share/data/test')

#for loop traversal to read
for i in name_list:
    df = pd.read_excel(r'D:/Data-Science/share/data/test/' + i)
    df = df.drop_duplicates() # remove duplicates
    print('{} read complete!' .format(i))

month_num = ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December']

for i in month_num:
    os.mkdir('D:/Data-Science/share/data/' + i)
    print('{} creation complete! .format(i))

import os

#Get the names of all files under the specified file
old_name = os.listdir('D:/Data-Science/share/data/test')

name = ["ZhangMingMing","LiDan","WangYueYue","ChenKai"]

# iterate through each name
for n in name:
    # Iterate through each old file name
    for o in old_name:
        #Determine if the old file name contains a specific name
        #If it does, rename it
        if n in o:
            os.rename('D:/Data-Science/share/data/test/' + o, 'D:/Data-Science/share/data/test/' + n + "March Performance.xlsx")

import os
import pandas as pd

# Get the names of all files under the specified file
name_list = os.listdir('D:/Data-Science/share/data/sale_data')

# Create an empty DataFrame with the same structure
df_o = pd.DataFrame({'date':[],'sales':[]})

# iterate through and read each file
for i in name_list:
    df = pd.read_excel(r'D:/Data-Science/share/data/sale_data/' + i)
    # for vertical splicing
    df_v = pd.concat([df_o,df])
    # the result of the stitching to df_o
    df_o = df_v
df_o   

# Generate a new month column
df_o['month'] = df_o['date'].apply(lambda x:x.month)

# iterate through each month value
for m in df_o['month'].unique():
    # filter out the data for a specific month value
    df_month = df_o[df_o['month'] == m]
    # will be filtered out the data to save
    df_month.to_csv(r'D:/Data-Science/share/data/split_data/' + str(m) + 'monthly_sales_daily_after_split.csv')