Python Forum
deleting columns in CSV file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
deleting columns in CSV file
#2
import pandas as pd

data = {
    1: [1, 19, 20, 21, 25, 29, 30, 31, 30, 29, 31],
    2: [2, 10, 20, 20, 20, 10, 10, 20, 20, 10, 10],
    3: [3, 10, 20, 20, 20, 10, 10, 20, 20, 10, 10],
    4: [4, 10, 20, 20, 20, 10, 10, 20, 20, 10, 10],
}

df = pd.DataFrame(data)
Delete columns from 2 to 4,adjust as needed.
>>> df
     1   2   3   4
0    1   2   3   4
1   19  10  10  10
2   20  20  20  20
3   21  20  20  20
4   25  20  20  20
5   29  10  10  10
6   30  10  10  10
7   31  20  20  20
8   30  20  20  20
9   29  10  10  10
10  31  10  10  10

>>> df.drop(df.columns[2:4], axis=1, inplace=True)
>>> df
     1   2
0    1   2
1   19  10
2   20  20
3   21  20
4   25  20
5   29  10
6   30  10
7   31  20
8   30  20
9   29  10
10  31  10
Reply


Messages In This Thread
deleting columns in CSV file - by astral_travel - Nov-25-2022, 09:53 PM
RE: deleting columns in CSV file - by snippsat - Nov-25-2022, 10:37 PM
RE: deleting columns in CSV file - by astral_travel - Nov-26-2022, 12:31 PM
RE: deleting columns in CSV file - by deanhystad - Nov-26-2022, 01:33 PM
RE: deleting columns in CSV file - by astral_travel - Nov-26-2022, 02:26 PM
RE: deleting columns in CSV file - by snippsat - Nov-26-2022, 02:35 PM
RE: deleting columns in CSV file - by astral_travel - Nov-26-2022, 05:23 PM
RE: deleting columns in CSV file - by snippsat - Nov-26-2022, 07:14 PM
RE: deleting columns in CSV file - by astral_travel - Nov-26-2022, 09:36 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Create Choices from .ods file columns cspower 3 644 Dec-28-2023, 09:59 PM
Last Post: deanhystad
  Create csv file with 4 columns for process mining thomaskissas33 3 796 Nov-06-2023, 09:36 PM
Last Post: deanhystad
  Converting a json file to a dataframe with rows and columns eyavuz21 13 4,654 Jan-29-2023, 03:59 PM
Last Post: eyavuz21
  Replace columns indexes reading a XSLX file Larry1888 2 1,008 Nov-18-2022, 10:16 PM
Last Post: Pedroski55
  rows from sql query need to write to a file as columns sjcsvatt 6 2,450 Oct-09-2021, 12:45 AM
Last Post: snippsat
  [Solved] Using readlines to read data file and sum columns Laplace12 4 3,616 Jun-16-2021, 12:46 PM
Last Post: Laplace12
  Python Matplotlib: Create chart for every 4 columns in Excel file JaneTan 2 2,808 Feb-28-2021, 05:02 AM
Last Post: JaneTan
  How to fill parameter with data from multiple columns CSV file greenpine 1 1,687 Dec-21-2020, 06:50 PM
Last Post: Larz60+
  Read strings and numbers in columns from a file suvadip 4 2,943 Aug-11-2020, 09:37 PM
Last Post: suvadip
  Rearrange Columns in a CSV File rjj920 1 5,613 May-09-2020, 03:26 PM
Last Post: DPaul

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020